software

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
www.contextures.com/xlfaqApp.html#Unused--
Regards Ron de Bruin
www.rondebruin.nlquot;Suzaquot; gt; wrote in message news
gt; One of my often used files is now 4MB which by copying individual sheets to a
gt; new file, this became 64kb. This took a while and I had equally to reset up
gt; freeze panes, column widths etc.
gt;
gt; There must be an easier way? I feel that my file needs 'defrag'ing in Excel
gt; speak? Compressing? What is the answer/key word to find out how to do this.
gt; This is not the first time this has happened. I am sure this is a common
gt; problem with an easy solution?
gt;
You may want to see if you have any hidden shapes/pictures/controls on those
worksheets.

Suza wrote:
gt;
gt; One of my often used files is now 4MB which by copying individual sheets to a
gt; new file, this became 64kb. This took a while and I had equally to reset up
gt; freeze panes, column widths etc.
gt;
gt; There must be an easier way? I feel that my file needs 'defrag'ing in Excel
gt; speak? Compressing? What is the answer/key word to find out how to do this.
gt; This is not the first time this has happened. I am sure this is a common
gt; problem with an easy solution?

--

Dave Peterson