Hi all,
I have a group of basic users who somehow always manage to max out the rows and columns in their spreadsheets. This of course increases the file size alot but also slows the system down as well as it eats up memory.
Is there an excel setting that will cap the row count and/or the column count? VBA or hiding rows would not work as I would have to be there every time they create a new file to work on. Also would prefer to maintain excel functionality and formatting capabilities to the extent possible. I have looked around in the forum and via google and have not been able to find a solution.
thank you in advance,
T
I have a group of basic users who somehow always manage to max out the rows and columns in their spreadsheets. This of course increases the file size alot but also slows the system down as well as it eats up memory.
Is there an excel setting that will cap the row count and/or the column count? VBA or hiding rows would not work as I would have to be there every time they create a new file to work on. Also would prefer to maintain excel functionality and formatting capabilities to the extent possible. I have looked around in the forum and via google and have not been able to find a solution.
thank you in advance,
T