Workbook Size

[Bernie Beal]

MS Excel Newsgroup:

I had occasion to create two Tables in Excel. The first file is one page in
length and uses approximately 762 Kb memory. The second Table is seven pages
long and only uses 77 Kb memory.

Can anyone explain this?

Bernie Beal
bquest@optonline,net

 

[Norman Harker]

Hi Bernie!

Most likely cause is a false end of used range in the first workbook.

See:
Debra Dalgleish:
http://contextures.com/xlfaqApp.html#Unused

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Dave Hawley]

Hi Bernie

This page normally solves the problem
http://www.ozgrid.com/Excel/ExcelProblems.htm

However, with Pivot Tables youy should NOT use entire Columns as their
Source. Dynamic Named Range are ideal for this:
http://www.ozgrid.com/Excel/DynamicRanges.htm

See also the link below for more PT fundamentals.
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****