Microsoft Excel solution developers need to be in the “perfect” place at the right time.
They need to know when to open their solution.
But it can be difficult to pinpoint the ideal time, especially when it comes to new features that might be in use, says Kevin Lefkowitz, CTO at Excel.
With the latest Excel SDK, Microsoft is introducing a new “time to open” metric.
When to open?
“You need to have the right answer in mind, but it doesn’t matter what the answer is,” Lefkoowitz says.
“It’s just time to use it.
You can have a lot of different ideas, but the most important thing is to be right at the time.”
Here are some examples of when to use the new metric: • If you’ve recently opened an Excel 2010 or earlier solution and are just getting started with Excel 2007.
• If your solution is using the new “previous” functionality in Excel 2007, or you’ve been using Excel 2010 since January 2013.
• When you’ve built your first spreadsheet in Excel 2010, which one is the most popular?
You can use this time to expand your existing solution to include more options, or to add a new function or feature.
• You’ve built a new solution in Excel 2012.
You may be wondering if you should be using the “next” functionality for this new solution.
Yes, you should.
“In Excel 2012, it’s not uncommon to see solutions that are not yet fully functional, which is great,” says Jeff Johnson, CMO of Jigsaw Solutions.
“As an Excel user, the next step is to move to the new solution, which means the new functionality must be added.
That’s the time to do that.”
To get started, go to the Settings > Excel Options > New Solution > New Time to Open to see how the new time-to-open metric changes the experience.
You will want to create a new Excel solution with a name that is consistent with the “previously” functionality.
The name should be a unique, memorable phrase, like “new Excel solution.”
You should also create a solution with the name of a previous Excel solution.
For example, if you had a new spreadsheet in 2012, you might create a spreadsheet named “2012 Excel solution,” then create a “new” solution named “2011 Excel solution” and so on.
Once you have created your new solution and set the name to a memorable phrase like “old Excel solution, we will need to add the next feature,” open it, and it will automatically open with the new feature.
“The new time to opens is the same in Excel 2013 as in Excel 2011,” Johnson says.
• How can I tell if I’ve reached a point where I’m too late to make a new project?
The new time is the time it takes to open the solution, so it’s important to use this metric when you see an error message in your output.
If you see a message like “You have reached the point of no return,” it means you haven’t reached a moment of maximum efficiency.
You are probably just past the point where you need to expand the solution to make changes, Johnson says, so you may want to try to expand it again.
• What about creating a new sheet that contains a new feature?
“The goal is not to create new features for your Excel 2010 and Excel 2012 solutions, but to make your Excel solution work better,” Johnson explains.
“There is no need to create an entirely new Excel sheet just for the new features you want to add to your solution.
You could have a new excel sheet that includes an Excel function that you didn’t know existed, or an Excel task that you’ve never used before, and then create new Excel sheets with that task and the new functions.”
Lefkovitz says this approach will help you to avoid the error message.
If it does, the most you should do is create a second Excel solution that includes the new Excel features.
“If you have a problem with a particular Excel function, you can go back to that Excel sheet and try to add it back,” Lifes says.
If there are no new Excel solutions in your spreadsheet, then it may be that you don’t need to open a new one.
But if you do open a second sheet with the old Excel functions, you may be able to see the new versions of the Excel functions in your solution, and this is a good sign.
• I see a “too many options” message.
The problem is that I have too many options.
If this is the case, the solution is too complex.
It may be a case of a spreadsheet that’s getting too large.
If the problem is related to the Excel 2010 solution or the Excel 2012 solution, it could be that there are too many Excel functions that need to appear in your new Excel worksheet.
If so, you’ll want to expand