Software

Ask something
Question Locked

Regarding Excel

0 helpful
2 replies

by shahi1982

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
does the file of the excel file decrease the speed of working on excel ? ya i know speed of the computer decrease the speed of woking but i have 512mb Ram .so can i know does the size of excel file decreases the speed of working on excel ?

2 replies

by thumbsup2

Yes, the size of the file being loaded into memory will decrease the speed of Excel. The larger the file grows, the slower it will become, especially with only 512MB of RAM. Also, having autosave turned on will slow things down (actually hesitate) while it's saving.

I have a file which is restarted each year. As the file grows to nearly 10,000 records toward the end of the year, it gets extremely slow to type in cells or run macros.

This discussion is closed to new replies.