How do I create a new workbook in Excel 2010 format?
I'm currently using Excel 2010 but when I create a new workbook with Control-N or with VBA (Workbooks.Add), I get a 2003 style book that opens in Compatibility mode with only 256 columns. How do I create one with the standard 1,048,576 rows and 16,384 columns in Excel 2007 and 2010? I tried saving the new workbook as an .XLSM but that didn't help.
Better still, since I've already populated 4 sheets with a lot of data in a new workbook before realizing that it was 2003 style, is there a way to convert those existing sheets to 16,384 columns?
I have no idea how I created my first Excel 2010 workbook in the first place.
This is very perplexing to me.
Thanks,
John
Better still, since I've already populated 4 sheets with a lot of data in a new workbook before realizing that it was 2003 style, is there a way to convert those existing sheets to 16,384 columns?
I have no idea how I created my first Excel 2010 workbook in the first place.
This is very perplexing to me.
Thanks,
John
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
tqfdotus, you actually posted first but I want to split the points since ThinkSpaceSolutions' boldface Go to File > Options > Save jumped out at me first.
Thank you both!
John
Thank you both!
John
No problem, we are here to help! Thanks, ThinkSpaceSolutions!
No worries. Experts should be more worried about providing solutions and relative information rather than focusing on points anyways (imo). Glad I could help nonetheless.
Thanks tqfdotus and gabrielPennyback.
Thanks tqfdotus and gabrielPennyback.
Sorry, I should have refreshed before posting. :)