Forum Discussion
Excel File Size 8992kb!!
Hi All,
We have a couple of files that contain some sort of data to the boundaries of the sheets, and performing CTRL SHIFT END brings me to cell WJJ 288888. File size is 8992kb!!
I have trie...
Hi WIlly,
When I use the CTRL SHIFT END function to take me to the end of each sheet, it goes to WJJ 28888,
there is only data cells used to around AD 253. The end of the sheet should not be so far, so by clearing the contents of unused cells, it will reduce the size of the file, I know how to do this, but because there are around 100 sheets in the file with this issue, I can't do it for every sheet, it would take hours that I don't have
And I wouldn't expect the file to be over 1000KB, it's not that complex, it only has one totals sheet linking to each of the information sheets