I have a workbook that I (stupidly) started as an Excel 97-2003 Workbook. I didn't realize I did this until I did an IF statement longer than 7 levels of nesting. I tried to save it as an "Excel Macro-Enabled Workbook" and as an "Excel Workbook"... but the levels of nesting is still being limited to 7. Should this be happening? Any ideas on how to fix it?
Thank-you!
Hi Lewej23,
No, assuming 2010 is the same as 2007, the level of nesting is 64.
Close and re-open the workbook and try again as Excel will then realise that the workbook is indeed saved in the current version (a sign that you've done the process correctly is that the "[Compatibility Mode]" flag that forms part of the filename will have disappeared).
HTH
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
HA! I think I might love you! I closed the "Excel Macro-Enabled Workbook", re-opened it and re-did the longer IF statement and it worked... thank-you,thank-you, thank-you!!!!!
Bit hard considering I'm in Australia and you're in the USA - but thanks anyway!! I'm glad to know we got it sorted for you.I think I might love you
Robert
Well, I did date someone from Northern Ireland for around 10 months...... but he was working in the USA for 7 of those months!
Alas, I have no travel plans at the momentHave you ever been to Oz?
The only 2 places outside the USA I've been is Ireland & Northern Ireland. Unless you count the 2 times that I was at the Canadian border.
So, no, I've never been to Oz...
If you ever do, I'm sure you'll enjoy it. Have a good weekend. Robert.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks