Share via

Buggy excel

Anonymous
2018-08-29T11:26:35+00:00

I have created a file in excel which is far larger than it should be.  It's about 70MB and very buggy (takes ages to load, save, make changes and crashes frequently).  It creates dialogue boxes telling me that simple instructions will take a long time to complete.  It has 8 active tabs which are linked and working together.  There are only a few formula commands, but none are complex (IF, SUM etc).  It strikes me that there are some corrupt data fields or commands but I don't know how to troubleshoot the coding or fix the problem.  I'm working 32-bit version.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2018-08-29T11:44:46+00:00

    If you feel something has got corrupted, you need to prepare a new workbook and move the values from old workbook to new one.

    However, optimizing excel workbook will require you to go throgh some literarature on this. This will be value adding to you also.

    Most of your questions are answered at below links -

    Excel 2010 Performance: Improving Calculation Performance - http://msdn.microsoft.com/en-us/library/ff70051...

    Excel 2010 Performance: Performance and Limit Improvements - http://msdn.microsoft.com/en-us/library/ff70051...

    Excel 2010 Performance: Tips for Optimizing Performance Obstructions - http://msdn.microsoft.com/en-us/library/ff72667...

    Excel Calculation Bottlenecks - http://www.decisionmodels.com/optspeedd.htm

    Top 10 List of Performance Issues in Excel Workbooks - http://blogs.technet.com/b/the_microsoft_excel_...

    Was this answer helpful?

    0 comments