|
JP1 Remotes
|
View previous topic :: View next topic |
Author |
Message |
vickyg2003 Site Admin
Joined: 20 Mar 2004 Posts: 7073 Location: Florida |
Posted: Thu Mar 19, 2009 9:52 am Post subject: Excel |
|
|
This may seem a little off topic, but it is JP1 related and since this group really makes use of excel I thought I'd ask.
My workbook keeps getting bigger and bigger, everytime I save it. I'm an excel newbie and I did some stupid things like formating columns and rows instead of cell ranges. So I cleared all on the unused areas in all my worksheets, and saved it and it got even bigger!
Any tips on how to shrink this monster? |
|
Back to top |
|
|
dspille
Joined: 15 Mar 2009 Posts: 23
|
Posted: Thu Mar 19, 2009 10:29 am Post subject: |
|
|
You don't by any chance have "track changes" enabled do you? (Tools-Track Changes). |
|
Back to top |
|
|
underquark Expert
Joined: 20 Jun 2005 Posts: 874 Location: UK |
Posted: Thu Mar 19, 2009 10:59 am Post subject: |
|
|
Beware trusting Excel with large (or mission-critical) spreadsheets as they sometimes leap in size and then fail to open - usually just before a tax return is due. Best copy the data (select range, [ctrl]-c, [Alt]-esv) to a new workbook. |
|
Back to top |
|
|
ElizabethD Advanced Member
Joined: 09 Feb 2004 Posts: 2348
|
Posted: Sat Mar 21, 2009 7:04 pm Post subject: |
|
|
Vicky,
If the spreadsheet is KM, then I don't know, never saw it get bigger and bigger.
If it;s some other spreadsheet, it's likely you have some cells filled well out of range of what you think you're using, or your may have formatted entire rows or entire columns while adding something like borders or other cosmetic stuff. Also, remember, hitting spacebar over some text in a cell instead of the delete key (in order to delete data) fills the cell with spaces, so excel has to think it's really important data there
That said, put the cursor on cell A1. Now click Ctrl-End. Is it at the end of your data, where you think it should be, or some other place. What is the cell address? and what is the cell address you think data ends.
I might help you more if you tell me. And UQ is right - backup, backup, backup, version numbers and all.
Excel space-use CAN be tamed. BTW which excel version are we talking about? _________________ Liz
Tweeking 8910, HTPro/9811, C7-7800, 6131o, 6131n, AtlasOCAP-1056B01, RCA-RCRP05B and enjoying the ride |
|
Back to top |
|
|
vickyg2003 Site Admin
Joined: 20 Mar 2004 Posts: 7073 Location: Florida |
Posted: Sat Mar 21, 2009 7:17 pm Post subject: |
|
|
Quote: | You don't by any chance have "track changes" enabled do you? (Tools-Track Changes). |
No, but now I know about it. Thanks for the tip.
Quote: | If the spreadsheet is KM, then I don't know, never saw it get bigger and bigger.
If it;s some other spreadsheet, it's likely you have some cells filled well out of range of what you think you're using, or your may have formatted entire rows or entire columns while adding something like borders or other cosmetic stuff. Also, remember, hitting spacebar over some text in a cell instead of the delete key (in order to delete data) fills the cell with spaces, so excel has to think it's really important data there |
No, it was my a JP1 spreadsheet that I'm putting together. Apparently in my quest to get it right, I did something terribly wrong. It was gaining a half a meg with every save. I ended up rebuilding the entire sheet and the problem stopped.
I just hope I never have that happen again! I really dislike excel. |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|