 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / November 2007Spreadsheet Size Problems
I've been working on a XL spreadsheet using VBA Macros and the size of my sheet has grown by 10 times (1200kb to 12,000kb), and it is very, very slow. The amount of data processed hasn't grown much. Any idea what might have caused this? Thanks This tends to happen after working for some time in an mdb. Try running the repair utility. It should do the trick. Tools \Database Utilities\Compact And Repair Database > I've been working on a XL spreadsheet using VBA Macros and the size of > my sheet has grown by 10 times (1200kb to 12,000kb), and it is very, > very slow. The amount of data processed hasn't grown much. Any idea > what might have caused this? Thanks My apologies, for some reason I thought you were using MS Access. Next time I'll pay closer attention. > I've been working on a XL spreadsheet using VBA Macros and the size of > my sheet has grown by 10 times (1200kb to 12,000kb), and it is very, > very slow. The amount of data processed hasn't grown much. Any idea > what might have caused this? Thanks Hi Kim, There are many possibilities. Complex array formulae, for example, can create quite a performance hit, especially if their ranges are unnecessarily large. I suggest asking in an Excel forum - this one's for Word. Cheers  Signaturemacropod [MVP - Microsoft Word] ------------------------- > I've been working on a XL spreadsheet using VBA Macros and the size of > my sheet has grown by 10 times (1200kb to 12,000kb), and it is very, > very slow. The amount of data processed hasn't grown much. Any idea > what might have caused this? Thanks test > I've been working on a XL spreadsheet using VBA Macros and the size of > my sheet has grown by 10 times (1200kb to 12,000kb), and it is very, > very slow. The amount of data processed hasn't grown much. Any idea > what might have caused this? Thanks
|
Reply to this Message |
 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.