PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Setup formula/function usage creating huge file size?

Reply

formula/function usage creating huge file size?

 
Thread Tools Rate Thread
Old 10-07-2003, 07:58 PM   #1
Walt F
Guest
 
Posts: n/a
Default formula/function usage creating huge file size?


I have an Excel 2000 spreadsheet that uses VLOOKUP to
equate text values (a drop down validation list) with
numeric values (to calculate a score). The workbook has 5
tabs but none of the spreadsheets are especially large.
Each row has 3 VLOOKUP instances. But the file size is
13Mb. My PC can barely process the file it's getting so
big.

I am not using any VBA functions, and I ensured that no
Macros exist. All I'm using are data validations, VLOOKUP
and some simple calculations based on the results of the
lookup.

Any hints on what is causing the huge file size and what I
might do to minimize it?
Thanks, Walt
  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off