upgrading from Excel 2007?
upgrading from Excel 2007?
(OP)
I happily use Excel 2007 on my office computer (3-4 year old Dell with Windows 7). And on my 10 year old Sony Vaio running Windows Vista. And I happily use a lot of VBA in the process.
I just purchased a new personal laptop with Windows 10 and debating about getting Excel 2016. The reviews at the Microsoft Store website are not encouraging.
I have hundreds of workbooks (work and personal) in which I've invested probably thousands of hours. I really do not want to lose this work.
What sort of view do folks have on Excel 2016? Am I certainly going to run into difficulty?
thanks!
I just purchased a new personal laptop with Windows 10 and debating about getting Excel 2016. The reviews at the Microsoft Store website are not encouraging.
I have hundreds of workbooks (work and personal) in which I've invested probably thousands of hours. I really do not want to lose this work.
What sort of view do folks have on Excel 2016? Am I certainly going to run into difficulty?
thanks!





RE: upgrading from Excel 2007?
Don't get Word. The spell check is so onerous that I've learned to how spell again.
RE: upgrading from Excel 2007?
- Some functions such as UCase and LCase must now be preceded by VBA (but this is probably not Excel 2016 related anyway).
- Using worksheetfunction.Transpose on very big arrays (more than 64,000 rows) now returns a truncated array (with no warning), rather than an error (introduced in Excel 2013).
As for the charts, its a matter of taste, but you can set up styles for the way you want anyway.The symbols are listed by sub-set, and the square root symbol appears when the mathematical symbols sub-set is selected, and it also returns to the last sub-set used when you re-open, so I can't see that there is an awful lot of wading required.
I haven't had any problems with the spell-check in Word.
See:
https://newtonexcelbach.wordpress.com/2014/03/08/p...
and
https://newtonexcelbach.wordpress.com/2016/01/01/w...
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: upgrading from Excel 2007?
The first point IDS noted caused a few issues on some code I had, took me a while to figure it out as you get the usual helpful error codes from Excel.
RE: upgrading from Excel 2007?
I guess there is a "trial" version of the new Office on my new computer, so I can try that for a taste of things to come, see if I like them.
RE: upgrading from Excel 2007?
Jim H / jimstructures
RE: upgrading from Excel 2007?
One problem I found is 2016 only ever creates one instance of excel unless you explicitly tell it to create a new instance whenever a sheet opens. This sometimes causes lockup problems and you don't know which sheet is causing it. Some sheets will be totally unresponsive, and you go round clicking on the X until something happens.
The other common problem is that it doesn't always ask you whether you wish to save or not before closing. I've had to re-enter everything twice quite a few times. Never had this problem when I was using 2003.
I'm also getting a lot more crashes and recovered sheets ever since I started using 2016.
One advantage is you can now save to PDF.