IrishCharm
02-15-2010, 06:53 AM
Hi,
I am having problems with a 30 mb spreadsheet (the 30mb alone is one problem all in itself!)
Basically I think that it has reached its formatting allowance, i.e. if i go to either insert a formula, say S2-D4, it will not allow me to insert this as it says I have reached max formatting. Also if there are dates which are numeral format and I want them in "dd-mmm-yy" format this will not work either as it says I have reached my max format. I cant even colour in cells.
I tried to unformat some cells to try and make it easier but it wont even allow this. Any ideas of how to clear this spreadsheet up since I cant do anything at all with it or do i need to start a new one from scratch?
Thanks
Sarah
:help
I am having problems with a 30 mb spreadsheet (the 30mb alone is one problem all in itself!)
Basically I think that it has reached its formatting allowance, i.e. if i go to either insert a formula, say S2-D4, it will not allow me to insert this as it says I have reached max formatting. Also if there are dates which are numeral format and I want them in "dd-mmm-yy" format this will not work either as it says I have reached my max format. I cant even colour in cells.
I tried to unformat some cells to try and make it easier but it wont even allow this. Any ideas of how to clear this spreadsheet up since I cant do anything at all with it or do i need to start a new one from scratch?
Thanks
Sarah
:help