Dear Members,
If we are using a very big excel file with lot of formulas, you often encounter the problem of "Slow response" from excel file. Is there a way to increase the speed of response? If yes, please explain how this is possible.
Thanks&Regards
Ramesh
Use more efficient formulas
Use non-volatile formulas wherever possible
Avoid array formulas whenever possible
Limit the range of references to be the minimum necessary
Arrange the sheet so that most references are to cells to the left or above
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks