Calculating cells
while working with a worksheet my excel takes nearly 30 - 40 seconds for
calculation and a bar appears at bootom telling calculating cells 5% ,10% like that .What it is why it is taking so much of time for updating a cell |
Calculating cells
If you have lots and lots of formulas, then that could be the problem.
If you're doing data entry, maybe turning calculation to manual would be ok. Toggle it back to automatic when you're done with the data entry. Tools|Options|calculation tab is where that setting can be changed. TUNGANA KURMA RAJU wrote: while working with a worksheet my excel takes nearly 30 - 40 seconds for calculation and a bar appears at bootom telling calculating cells 5% ,10% like that .What it is why it is taking so much of time for updating a cell -- Dave Peterson |
All times are GMT +1. The time now is 01:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com