One of my often used files is now 4MB which by copying individual sheets to a
new file, this became 64kb. This took a while and I had equally to reset up
freeze panes, column widths etc.

There must be an easier way? I feel that my file needs 'defrag'ing in Excel
speak? Compressing? What is the answer/key word to find out how to do this.
This is not the first time this has happened. I am sure this is a common
problem with an easy solution?

See
http://www.contextures.com/xlfaqApp.html#Unused


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Suza" wrote in message ...
One of my often used files is now 4MB which by copying individual sheets to a
new file, this became 64kb. This took a while and I had equally to reset up
freeze panes, column widths etc.

There must be an easier way? I feel that my file needs 'defrag'ing in Excel
speak? Compressing? What is the answer/key word to find out how to do this.
This is not the first time this has happened. I am sure this is a common
problem with an easy solution?

You may want to see if you have any hidden shapes/pictures/controls on those
worksheets.

Suza wrote:

One of my often used files is now 4MB which by copying individual sheets to a
new file, this became 64kb. This took a while and I had equally to reset up
freeze panes, column widths etc.

There must be an easier way? I feel that my file needs 'defrag'ing in Excel
speak? Compressing? What is the answer/key word to find out how to do this.
This is not the first time this has happened. I am sure this is a common
problem with an easy solution?

--

Dave Peterson