Forum Discussion
I having Problem with Excel workBook with Huge Data.
Dear All,
I am having Excel workbook with Large number of data in side. While Opening The workbook.it becomes not respon
2 Replies
Well, it's a very common issue. It could be due to various reasons, such as large data sets, complex formulas, or compatibility issues.
Here are some things you should try in order to fix this issue-
- If your workbook includes complex formulas and calculations, try temporarily turning off the automatic calculation feature. Open new Excel, click on the "Formulas" tab, then "Calculation Options," and then choose "Manual."
- Open Excel in Safe Mode to disable any add-ins that may be causing conflicts. Hold down the "Ctrl" key or enter the "excel.exe /safe" command in the Run dialogue box. If the workbook opens without any problems in Safe Mode, it is likely that an add-in is to blame.
- Disable hardware acceleration by going to "File," selecting "Options," choosing "Advanced," and under the "Display" section, check the box for "Disable hardware graphics acceleration."
- If the problem persists, try repairing your Office installation. Open the Control Panel, go to "Programs" or "Add or Remove Programs," locate Microsoft Office, and choose the repair option.
Let me know if this works.
Best Regards.
Do you see in status bar some notifications about calculations process? What task manager says about the process?
