G
Guest
Guest
I have made a large file with many formulas, about 18 worksheets and some macros. I am using the manual calculation and when necessary I press F9 to calculate.
It takes time to calculate and it gets to about 40% then stops and it still says 'Calculate' on the bottom of the screen, prompting me to press F9. I press F9 again but the same thing happens. As a result I am not confident that the file is calculating fully.
I understand it will probably be because its a big file (6.5MB). But does anyone know why this is so? Does anyone have a remedy?
It takes time to calculate and it gets to about 40% then stops and it still says 'Calculate' on the bottom of the screen, prompting me to press F9. I press F9 again but the same thing happens. As a result I am not confident that the file is calculating fully.
I understand it will probably be because its a big file (6.5MB). But does anyone know why this is so? Does anyone have a remedy?