Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limiting Size of Excel 2007 Spreadsheet
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. -- Ben McCall |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limiting Size of Excel 2007 Spreadsheet
try hiding all the extra rows & columns............
:) susan On Dec 18, 1:43 pm, Ben wrote: 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. -- Ben McCall |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - security / limiting access | Excel Discussion (Misc queries) | |||
Worksheet Automation and Size Limiting | Excel Worksheet Functions | |||
Limiting cell size to 25 characters | Excel Discussion (Misc queries) | |||
Limiting size field MS query returns | Excel Discussion (Misc queries) | |||
Limiting the size of a worksheet | Excel Programming |