Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2013 very slow to open worksheets.

26 Aug 2019   #1
petey52

Win 7 Ultimate 64 bit
 
 
Excel 2013 very slow to open worksheets.

I have excel 2013 and been having issues when opening worksheets. The worksheets are VERY slow to open (sometimes about 1 minute) and all the while I am getting the "not responding" notification. My M/S Word worksheets seem to open very quickly still. I did install 16gb RAM 2 weeks ago but I don't think the issue could be related, could it? The Excel program itself opens quickly but the worksheets is what is hanging up. I have tried the "repair" option and still no change. I did have a password on these worksheets but I have since removed it. I do not know if that has anything to do with it as I removed the pw when the issue was happening. I have windows 7 Ultimate 64 bit. M/S home and student 2013.


My System SpecsSystem Spec
.
27 Aug 2019   #2
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Hi petey52, welcome to the Forum.

Your problem certainly could be the new RAM installation. Have you tried going back to the original RAM set up & seeing if that fixes it. Did you get professional advice on what RAM type & speed to use & whether it suits your motherboard & CPU.
My System SpecsSystem Spec
28 Aug 2019   #3
petey52

Win 7 Ultimate 64 bit
 
 

I do think I have the correct memory stick. Corsair Tech picked them from the vendor list for my motherboard. However, what negative complications would result if I changed back to the original memory sticks (8gb) after having installed (16gb)?
My System SpecsSystem Spec
.

28 Aug 2019   #4
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

If you have not made any other changes other than change the RAM, things should revert to what they were before you changed the RAM. Unless you have really big spreadsheets in Excel 8 GB of RAM should be adequate.

Having a larger RAM does not necessarily make the computer faster as there are a lot of other variables, such as the CPU, hard drive access time & the general quality of fitted components. For example, installing an SSD & reinstalling the operation system, will make a big difference if you have been using a hard disc drive.
My System SpecsSystem Spec
31 Aug 2019   #5
petey52

Win 7 Ultimate 64 bit
 
 

I think I found out what the problem was!!!! I had my excel workbook on my desktop for several months without having any problems with them loading or getting the "not responding" thing. In the last 2 weeks I "cleaned" up my desktop and consolidated the excel workbooks into a folder and named that folder "Excel Data", and it was on my desktop. That is when I started getting the buggy issues and slow to open thing. I discovered that if I opened the folder and dragged and dropped (NOT COPY and PASTE) the worksheet onto the desktop, that it would open cleanly and quickly. If I copied and pasted the file to the desktop but left a copy of that file inside the folder, it would still be buggy. Bottom line is: If I remove the worksheet that I want to work on completely from the folder on place it on the desktop, everything is OK. Placing it in a folder was the issue. Maybe because Excel couldn't find it with the folder in the path? Has anyone ever heard of this before? I am going to give it some time to verify that the problem is solved.
My System SpecsSystem Spec
01 Sep 2019   #6
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Working out the actual route a file uses to access a program can be very difficult, as there is a lot longer route than what we actually see when looking at the file data.

If you have just one file or a folder of files in your Document Library, the best way to set up access to that from the Desktop is to Right Click the mouse on the file or folder in question & select Send To with the Desktop (create shortcut) option. This provides direct access & is devoid of any unnecessary detours, which slow down access time.
My System SpecsSystem Spec
Reply

 Excel 2013 very slow to open worksheets.




Thread Tools




Similar help and support threads
Thread Forum
Excel 2013 cannot open simple text file with .acc extension
Inside .acc file is a simple text, but the mighty Excel tries to open it like some kind of database. It is asking for accounts, sources, passwords etc. and finally it cannot open it at all. It can open this file if I change extension to something else like .txt or .xls. How can I turn off this...
Microsoft Office
Excel 2013 Won't Automatically Open Files
I am running into a bizarre problem with Excel 2013 and I can't seem to figure out the cause - searching around I couldn't find a solution, either. I have both Office 2010 64-bit and Office 365 (2013) 64-bit installed on my Windows 7 system. The only reason I still need 2010 is that 2013's...
Software
If statements in Excel worksheets.
How do you add if statements to formula in Excel that change the formating of the cells. For instace: If I have a sum which subtracts one cell from another and I want the colour of the text in the results cell to turn red if the value becomes negative. And: If I have a number in a...
Microsoft Office
Need software to find duplicates in excel worksheets
Dear All, Can you plz suggest me a software that can find duplicate texts present in an excel file? I know there is an option called "Remove Duplicates" under Data section in excel, but it can only find duplicates present in the current worksheet. What i am looking for will allow me to...
Software
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 19:11.
Twitter Facebook