excel file lagging & buffering ?

Question

how to solve those excel file lagging & buffering ?

Answer 1

Excel for desktop or on line? If desktop, what version of Excel do you run? (Use the Menu Bar and choose Excel > About Microsoft Excel to find the version number)

Can you share a version of the file?

Why a sample file is important for troubleshooting - - - - - - - and how to do it.

Answer 2

Hello Roland268! I'm Gunasekar and I'd be happy to help you with your question.

I understand that you are experiencing a lag when opening the excel file on your MacBook.

1. Does this issue happen with all the excel files on your Mac?
2. May I please know the version or edition of the Office applications running on your PC?
3. Could you please let us know the Mac OS version?
4. Whether other applications also get the same problem? Such as PowerPoint or Word and etc.

“In this article http://answers.microsoft.com/thread/4fb45444-1b7e-40c2-b182-c809033dc057 Waqas Muhammad MSFT | Microsoft Agent shows the solution to the problem can be solved by following these steps"-

1.First please try to reboot Mac in safe mode and determine whether background programs are causing the issue. For detailed information, please check this article.

https://support.microsoft.com/en-us/help/2398596/how-to-use-a-clean-startup-to-determine-whether-background-programs-ar

2. If you installed add-ins on Excel, disable them.
3. . Another suggestion is to remove the Office folders from Containers folder in Library with following steps.

a: Completely quit all Office apps

b: In Finder, press COMMAND +Shift+g.

c: Enter ~/Library and click Go

d: Go to Containers folder, find the folder called Microsoft Excel or com. Microsoft.Excel

e: Move this folder to your desktop by cut&paste .

f: Relaunch Excel for Mac application and see the results.

4.If the problem with all Excel files even new created Excel document on your Mac OS, then I suspect components were corrupted somehow. You can go to the Applications folder In Finder and drag Microsoft Excel.app to the trash. Then Restart your Mac Download this installer Install package and use it to reinstall Microsoft Excel. Then, restart your Mac and test.

Update history for Office for Mac - Download and install the latest version of Excel 16.83 from the given link below and check if it helps.

https://learn.microsoft.com/officeupdates/update-history-office-for-mac

Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

I hope this information helps. If you have any questions, please let me know and I will be happy to help you further.

Best regards,

Gunasekar N