flightjock
New Member
- Joined
- Mar 18, 2002
- Messages
- 48
One of my workbooks, containing just a few sheets with a limited nr of rows and cols had grown to the incredible size of >14Mb. When I incidently looked in the (Alt-F11) Project explorer I saw that the sheets in this workbook had very odd names, such as "sheet211111111111111111111111111111". Trying to solve the problem I created new empty sheets in the workbook, copied the contents of the old sheets into the new ones, deleted the old sheets and saved the workbook.. To my surprise, the filesize had shrunk to a few hundred kb.
OK, so I solved the problem, but I don't understand how it came up and how to prevent it in the future. Any advice would be more than welcome
OK, so I solved the problem, but I don't understand how it came up and how to prevent it in the future. Any advice would be more than welcome