Excel Size limitations

[gard0128]

I am currently managing sales forecast information in an Excel (XP) environment.

I am concerned that, as our product line expands, I may run into file size issues.

Currently, my file size is 2,229 KB, but is expanding. This is a multi-tab workbook and I have intentions on adding additional sheets to manage better on a customer level.

Is there a size limit where Excel begins to have problems?

Thank you.

 

[Dreamboat]

Open each sheet.
Click on Cell A1.
Hit Shift-Ctrl-End
Does it select beyond your data?
If so, select all blank columns (select first blank column, then Shift-Ctrl-Right arrow), then Edit-Clear-All.
Do the same if selection is beyond rows at the bottom (select first blank row, then Shift-Ctrl-Down arrow, Edit-Clear-All). Save your file after that.

Also, don't copy January to make FEb, then Feb to make March. Making a copy of a worksheet, then another copy off the copy, etc., can increase file size--cause corruption.

Anyway, I believe file size is limited by RAM on PC. Help file has limitations, just type in limitations I think. Or specifications.

http://www.TheWordExpert.com

 

[Rhort]

2Mb? I have an 8Mb sheet in Excel, so you've a while to go yet But other than that, I think Dreamboat is right, it's limited by physical memory.

 

[SkipVought]

Hi, gard0128,

One of my suggestions to you is to think of each sheet in your workbook as a file or table of data that, in it's desciption, is different than any other sheet. If you have data on multiple sheets where the headings are virtually identical and the tabs categorize it somehow (like Jan, Feb, Mar... tab), that data belongs on ONE SHEET with an additional column for DATE. Excel has fucntionality to Group and Outline by certain data parameters.

Make a distinction between DATA that you store, manipulate and analyze and REPORTS where you summarize and caregorize. DATA is dull, columnar but very useful. REPORTS can be glitzy and informational - you get good reports from well-organized data.

Just a few thoughts. Skip,
metzgsk@voughtaircraft.com