Hello,
a colleague of mine is experiencing a weird problem with a number of his workbooks in excel 2007. His workbooks grow a lot when performing seemingly innocent actions. An example from yesterday:
Adding a few hyperlinks to other sheets in the workbook caused the document to grow from 1 072k to an overwhelming 38Mb. No other operations than adding the links were performed between saves.
The document is in excel 97-03 format and he's working in excel 2007.
For some reason, deleting all rows and columns outside the used range of the worksheets (but not neccessarily the worksheet where the canges were made) brings the filesize back to normal for some reason.
If anyone can shed some light at what's happening we'd be very grateful.
Thanks in advance
a colleague of mine is experiencing a weird problem with a number of his workbooks in excel 2007. His workbooks grow a lot when performing seemingly innocent actions. An example from yesterday:
Adding a few hyperlinks to other sheets in the workbook caused the document to grow from 1 072k to an overwhelming 38Mb. No other operations than adding the links were performed between saves.
The document is in excel 97-03 format and he's working in excel 2007.
For some reason, deleting all rows and columns outside the used range of the worksheets (but not neccessarily the worksheet where the canges were made) brings the filesize back to normal for some reason.
If anyone can shed some light at what's happening we'd be very grateful.
Thanks in advance