The Excel 2007 help site as well as in the application refer to new functionality for expanding the maximum number of rows beyond 65k. I've tried the help functions as well as looking online and I can't find how to turn on this feature. Is anyone familiar with this?
Hi,
Not sure what you mean by 'turn on'. If you have Excel 2007 you already have 1m + rows
Rgds
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my post.
You're in compatibility mode.
Save the workbok as a native xlsx or xlsm file, then close and reopen.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
You would need to convert any existing workbooks to 2007 format in order to get additional rows.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks