My worksheet originally had formulas in it that referred to named ranges.I have deleted all formulas in my worksheet and all named ranges.There are no circular references etc.I have closed it and saved it.
Why is it that my worksheet still displays this message "calculating cells" when there is nothing to calculate.This is very frustrating as my spreadsheet is painfully slow.Even inserting a column can take 2 minutes.Interestingly,if i hit escape the problem is temporarily fixed but the message is still displayed.
I have gone into options and turned the calculation on and off,with no solution here.
Also just a curious point.If i save a blank excel file it takes up 14kb of memory.Seems a lot with no data.Does it have anything to do with DLL's??
Look forward to your response
Sincerely
Budge
Why is it that my worksheet still displays this message "calculating cells" when there is nothing to calculate.This is very frustrating as my spreadsheet is painfully slow.Even inserting a column can take 2 minutes.Interestingly,if i hit escape the problem is temporarily fixed but the message is still displayed.
I have gone into options and turned the calculation on and off,with no solution here.
Also just a curious point.If i save a blank excel file it takes up 14kb of memory.Seems a lot with no data.Does it have anything to do with DLL's??
Look forward to your response
Sincerely
Budge