Limiting Size of Excel 2007 Spreadsheet

B

Ben

How can I restrict the size of an Excel 2007 spreadsheet to be compatable
with Excel 2003? I have many macro programs as parts of about 30 different
spreadsheets in Excel XP to Excel 2003 that will not work in Excel 2007.
Problems come from clearing data below bottom row to bottom of the
spreadsheet (row 65536) or from the right most column of data to the right
side of the spreadsheet (column IV). when these comands are executed in 2007
it takes 10 to 20 or so minutes for them to complete.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
how to add new row to table in Excel 2003? 3
Calculating subtotals 22
Excel using VB - save problem 6
Sub Workbook_Open not called when opening spreadsheet 6
troubleshooting excel files with links 2003 to excel 2007 3
Excel 2007 vs. 2003 differencies for custom format [h]:mm:ss 3
How could I split a spreadsheet containing 600 rows, so there's 100rows in each new workbook 6

Top