Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / December 2007

Tip: Looking for answers? Try searching our database.

Limiting Size of Excel 2007 Spreadsheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ben - 18 Dec 2007 18:43 GMT
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.
Signature

Ben McCall

Susan - 18 Dec 2007 19:04 GMT
try hiding all the extra rows & columns............
:)
susan

> 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
[quoted text clipped - 5 lines]
> --
> Ben McCall
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.