File Size

[Et3rnal]

I get excel files sent to me by somebody running excel 2000. The file
get from them might be just a very simple, 12 row spreadsheet with n
formulas, yet it will read approx 645kb. I can make an identical fil
either on office XP, or excel 2000 and yet mine is only 32kb.
checked and there are no hidden formulas, rows, macros, etc. Wha
could this be? The file is saved as microsoft excel workbook. Thi
isn't really an issue on a file this size, but when I get more comple
spreadsheets it really slows me down.

Any ideas?

 

[Norman Harker]

Hi Et3rnal!

It's probably because the Used Range extends below or to the right of
the effective used range.

See:
Debra Dalgleish:
http://contextures.com/xlfaqApp.html#Unused
Manual and VBA procedure for correcting the used range.

 

[Et3rnal]

The rows used are 1-17 and the colums are A-C This is set to prin
preview and the page breaks surround the above area. The scroll bar
go to row 23 and colum T

 

[Norman Harker]

Hi Et3rnal!

Then follow Debra's instruction:

To manually reset the used range:

Select the last cell that contains data in the worksheet [In your
case C17]
To delete any unused rows:
Move down one row from the last cell with data. [That's row 17 in
your case]
Hold the Ctrl and Shift keys, and press the Down Arrow key
Right-click in the selected cells, and, from the shortcut menu, choose
Delete
Select Entire Row, click OK.
To delete any unused columns:
Move right one column from the last cell with data. [In your case
that's column D]
Hold the Ctrl and Shift keys, and press the Right Arrow key
Right-click in the selected cells, and, from the shortcut menu, choose
Delete
Select Entire Column, click OK.
Save the file. Note: In older versions of Excel, you may have to Save,
then close and re-open the file before the used range is reset.

 

[Et3rnal]

Okay, I followed the instructions to a T, and the file size is is no
643kb. I'm not sure I understand how over 600kb if data can be hidden

 

[Norman Harker]

Hi Et3rnal!

Take a look at:

Charles Williams:
http://www.decisionmodels.com/memlimitsc.htm

You might get some tips there. Especially recommended is opening and
closing with Excel 2003. Make sure that you are saving as a 2003 file
and not an earlier version.

My inclination is to recommend opening a new workbook and copying and
pasting to the new workbook.

 

[Et3rnal]

Thanks, that helps.


I should be able to fix the proble