Excel spreadsheet
-
Wednesday, November 17, 2010 6:22 AM
Dear Team
We having heavy data in single excel so while opening excel file it take long time & some time it goes for recovery so all other files are hang so please give us proper solution for it
Hope for your kind co-operation
Thanking You,
Priyanka
All Replies
-
Wednesday, November 17, 2010 6:37 PM
Priyanka,
In order to help You we need to have more information to work with. Which version of Excel are You running? The latest service pack installed for the Office pack. It's quite normal that large files take time to get loaded but it should not put Excel in a hang mode. Files we work much with and that constantly grow can easily get corrupted. One solution may be to rebuild the file from scratch and in that way get a new file to work with. If there is a Anti-Virus program that scan files before open them You can test to turn it off to see if the file gets loaded faster.
Sorry but it does not exist any general solution for large files.
Kind regards, Dennis (http://xldennis.wordpress.com/)- Marked As Answer by Sally TangModerator Thursday, November 25, 2010 6:10 AM
.png)
