Force excel to open in a new instance by default office. We have a brand new computer with a fresh install of windows 10 pro and office 365 2016 running on it. Excel 2010 slow opening network files solutions experts. When trying to open a file, i get the progress bar that takes up to a minute to complete. Ill tell you how to manage multiple workbooks effortlessly, speed up a slow file, track. Solved opening excel 2016 files takes around 30 seconds. Word and excel are slow to open a file peter bowey.
Fixing problems with starting microsoft office word, excel, powerpoint 2016 opening slow document duration. Some, despite being only 21k over bt, took as much as 5 minutes to open. Excel slow loading in windows 10 microsoft community. You open the file from the network share location, or you save the file to the network share location. It is interesting, because if you first open excel from the start menu, then double click the xlsx file, it will open instantly. Office 2010 opens files slow from network in my home network, 100mbs fully switched with windows 7 and office 2010, opening documents from a network share takes 2030 seconds. However, there are many speedup tricks you can use to improve the performance of a slow excel spreadsheet.
Mapped a drive back to the old server, and the files still take ages to open. It may take longer to open and save your files, longer for excel to calculate your formulas, and longer for the screen to refresh after. The client just moved to a new office location and so the lan ip of the synology server has changed. Fix slow microsoft excel and speedup spreadsheet processing. When you try and open a file in word, excel, powerpoint etc then it takes ages to load in, the solution is here. Slow performance in excel 2010 after you enable the share. Some but not all excel workbooks appear in taskbar. If you are having problems opening your excel files after upgrading from windows 7 to windows 10, see errors opening office files after upgrading from windows 7 to windows 10. The size of the documents are small, in the range of 60100kb.
I have researched as much as poss, but no solutions. Excel 201020 slow opening xls files with links spiceworks. It takes upto 12 mins to open a network file of 1mb. Fix the excel file slowtoopen bug in windows 10 rod trent sep 30, 2015 this is one of the issues that has plagued me since upgrading my systems to windows 10, but due to a busy travel schedule and other miscellaneous work items, i just delayed digging in to figure out a solution. An office program is slow or may stop responding hang when you open a file from a network location. Why is calc so much slower at openingsaving files than ms. Mcafee support community excel files very slow to open. Now follow the instructions at the top of that screen. Im here to help, with solutions to five common nightmares found in excel 2007 and 2010. Fix the excel file slow toopen bug in windows 10 outline. This issue occurs after you enable the share workbook option and then create many custom views for a workbook.
This week, we had an issue with excel files opening slowly on the network. Users are using excel 20 to open excel 2003 spreadsheets with issues. By opening each spreadsheet in its own instance, the spreadsheet has a dedicated 2 gigabytes gb of memory to use. You need to check whether excel performs very slowly with one file, a few files or all files. Everything works fine other than the fact that shared excel files are taking a long time to open and save. This fix worked for me and now the documents open instantly. Working in microsoft excel doesnt have to be a hassle. Takes at least 10 seconds to open an excel file directly unless an instance of excel is already opened. Office is slow or stops responding when you open file from. I have tried a repair install of office 2010, but that did not cure the problem. May 22, 2019, i have the excel slow open problem, and while i have a realtek.
If you use file open within the excel application or doubleclick a file in windows explorer, the files will still open in the same instance as designed. Office 365, excel 2019, excel 2016, excel 20, excel 2010, microsoft office excel 2007, microsoft office excel 2003, powerpoint 2019, powerpoint 2016, powerpoint 20, powerpoint 2010, microsoft office powerpoint 2007, microsoft office powerpoint. The problem was the office file validation, which was pushed via windows update this week. When you create external references to other workbooks also called links, you can control if and when theyre updated. My user is on excel 2010 on windows 7 enterprise, running mcaffe. How excel determines the current mode of calculation. Less when you create external references to other workbooks also called links, you can control if and when theyre updated. Word and excel slow to open forums cnet excel very slow to open files windows 7 why is excel 2010 20 taking 10 seconds open any file. Got a whizzy new pc with office 2010 and sometimes excel documents are taking ages minutes to open.
I have the same experience with my dell xps using windows 10 and office 2010. You can help protect yourself from scammers by verifying that the contact is a microsoft agent or microsoft employee and that the phone number is an official microsoft global customer service number. How to fix issues with microsoft office opening files slowley. Excel 2010 files very slow to open solutions experts. It is only when i try to open the file directly from a folder or shortcut. This works in most cases, where the issue is originated due to a system corruption. I tried diasabling the addons, starting in safe mode. Everything worked fine for a few days, and then every time i attempt to open a word file or excel file i get the ms office dialog box that states please wait while windows configures microsoft office 2010. But if excel is not open and you happen to have some code stopped in a breakpoint, it will take forever. Since i upgraded my pc to windows 10 windows 10 pro 64 bit, my excel files now take up to 30 sec to open. Tech support scams are an industrywide issue where scammers trick you into paying for unnecessary technical support services.
A possible fix for the excel slow file opening bug. Office 2010 runs product configuration when opening word and excel just started using a new workstation with office 2010 installed by oem. Fix the excel file slowtoopen bug in windows 10 it pro. Excel files are slow to save open if the issue is with your computer or a laptop you should try using reimage plus which can scan the repositories and replace corrupt and missing files. Actually this fixed my problem for slowopening of local files as excel was still trying to scan network locations even when the file had no external references. Here are 10 tips to give your slow excel spreadsheet a little speed boost, and save you some time and frustration click to jump to that specific section.
Office 2010 opens files slow from network windows 7. In this video it is described that how to speed up wordexcel 2016. Running either office 20 or the latest office 2016, when opening an excel file from. Excel files very slow to open i have several servers where excel files take 10 15 seconds to open, disable antivirus and they open right up. Office 2010 introduced native 64bit versions of office products to take advantage of. Using either office 20 or the latest office 2016, opening an excel file from the file system takes about 20 seconds to load the file completely even if the file contains no data.
Find answers to excel 2010 files very slow to open from the expert community at experts exchange. Copy the file that is opening incorrectly, to your desktop. Excel not responding, hangs, freezes or stops working excel. Solved file server migration slow excel file opening. This method works only when you use the excel icon to open the application.
Find answers to excel 2010 slow opening network files from the expert community at experts exchange. A fix for the excel slow file opening bug bruceb news. While you have the problematic file open in excel, select. Tried changing the dde settings, have done a repair to the program. Does anyone have any solutions for excel files opening slowly with windows 10. Instructions to solve excel being slow in windows 10.
To do this, follow the steps for your operating system. Safe mode lets you start excel without encountering certain startup programs. There are times when an excel file doesnt open after a recent ms excel upgrade or windows upgrade. What are the reasons behind such an issue and what can users do to repair excel after upgrade. Do they open slow if you first open word excel, then open the file using file open. To check whether the file associations in the system are performing correctly, reset the excel file associations to their default settings. When i try to open the newly saved file, it is really really slow to open, say 5 10 minutes. Users used excel 20 to open excel 2003 spreadsheets with no issues.
This is important because if someone else changes a linked cells value, excel does not update the link and display the new value unless you tell it to. The only issue i have is i doubleclick an excel file on my desktop or my documents, it takes several minutes for the file to come up. Here are some of the reasons why excel files might not open after an upgrade. Office 365, excel 2019, excel 2016, excel 20, excel 2010, microsoft office excel 2007, microsoft office excel 2003, powerpoint 2019, powerpoint 2016, powerpoint 20, powerpoint 2010, microsoft office powerpoint 2007, microsoft office powerpoint 2003. Which has been happening a lot with windows 10 just being released as well. When you open or create another workbook an excel file that can. So the slow loading only occurs if i double click the excel file directly. The setting referred to above is most certainly in excel 2010. I love microsoft windows 10 but one thing that was really getting on my nerves was that excel was taking ages to open and save files. Since i upgraded my pc to windows 10 windows 10 pro 64 bit, my excel files now take up. Troubleshoot excel opening blank when doubleclick a file.
I thought it was a servernetworking issue however it does the same thing when the files are copied to the desktop and opened. Open the file again and check whether the performance improves. Excel 2010 20 is taking anything between 5 and 15 minutes to open some of these xls files. I find that this issue is most apparent when trying to open an excel file. Excel not responding, hangs, freezes or stops working. Why in calc spreadsheet saving is so slow os win7x64 ms office excel do this with it file in 10 times quickly. It happens as said also in windows 8, and in excel 2010 too. Slow performance in excel 2010 after you enable the share workbook option for a workbook under wireless network. Control when external references links are updated excel. Heres how to disable cortana in windows 10registry. When your microsoft excel spreadsheet slows to a crawl, you cant help but notice. I just upgraded my office 2003 to office 2007 and everything seems to be fine. Disable hardware graphics acceleration office 2010, 20, 2016 registry.
When we open excel it opens immediately and without issue, however if we open an excel file it takes around 30 seconds before the excel splash window comes up, then it loads with a grey windows inside of excel for another 15 seconds or so. File server migration slow excel file opening across network. What to do when excel opens very slowly bruceb news. If on windows 10, ive had better luck downgrading to office 20 compared to using 2016. Follow the instructions given on this page to make older programs. I also noticed that even when trying to add a formula, excel would freeze for awhile and would display the message not responding.
1585 760 1367 497 1064 542 1460 322 1250 611 1464 1150 1459 1091 1479 403 124 853 1584 968 1229 884 996 1278 828 1072 110 79 1346 634 1151 1466