LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default How to reduce an extra large worksheet?

My text table was going fine until there was some kind of hiccup resulting in
an abnormal exit. When recovered the file had changed from 18KB to 9496KB
and takes for ever to load. The work sheet instead of being 61 rows by AG
columns is now 61 rows by XFD columns. I cannot even delete one column, it
says "Excel cannot complete this task with the available resources. Choose
less data or close other applications." Task manager says there are about
2.3MB of physical memory available. Is there any way to fix this?

Thanks, John.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I reduce the range of a saved worksheet? John Britten Excel Discussion (Misc queries) 3 September 4th 08 09:46 AM
Mortgage calculation after a large extra payment Gary Wachs Excel Discussion (Misc queries) 6 April 16th 06 08:55 AM
Mortgage calculation after a large extra payment Gary Wachs Excel Worksheet Functions 4 April 16th 06 02:01 AM
looking for an one invoice on an extra large spreadsheet Teresa Excel Discussion (Misc queries) 1 March 17th 06 03:12 AM
How do I reduce the worksheet size ? Rueben Excel Discussion (Misc queries) 3 May 25th 05 07:15 PM


All times are GMT +1. The time now is 03:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"