excel files that have far too many active cells.
Posted on 2015-01-29
One of my eu's is having issues with spreadsheets. Any assistance is appreciated...
"So many of the spreadsheets I work with have grown out of control and are causing issues at certain points in time, especially when trying to do certain things like adding rows etc.
I have several excel files that have far too many active cells. This is causing issues when new rows need to be added to the worksheet, and often causes the file to become unresponsive. I am looking for solution to change/select the active cells in the worksheet so that my sheet is contained to only the rows/columns needed. In my current sheet, if I hit ctrl+end I go down to 1,048,574 rows. My real active row count is 850."