Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel 03 workbook size


  • Please log in to reply

#1
jshellen

jshellen

    New Member

  • Member
  • Pip
  • 1 posts
Hi,

I was given an Excel workbook containing 3 worksheets. The first worksheet is large - 171 columns and 732 rows - with many formulas and text. The other two worksheets are small. According to the person who asked me to review this workbook its size was always under 1 meg. Now the size is 4 megs. This person wants to know why the size increased.
I am looking for any suggestions as to why this workbook would increase in size to this extent. I looked for any duplication - did not see any.

Thank you,

jshellen
  • 0

Advertisements


#2
Jonesey

Jonesey

    Member

  • Member
  • PipPipPip
  • 335 posts
Seems awfully big, for what it is.

I've got a financial model with over 80 sheets, hundreds of charts, fully macro driven which is only 6 meg.

Have you added anything to it recently, such as conditional formatting?

If you hit <end><home> where do you end up? At the end of your data or down in cell IV65536?
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP