Excel Docs taking forever to open

[klarowe]

Ever since creating all the new reports that use multiple macros/codes, my work laptop has been rediculously slow only when working with any excel documents. At first I thought it was just from all the macros but ever other computer opens the documents just fine. Is there some sort of cache or something that would cause the documents to be so slow? I'm not sure if maybe its a computer issue or if for some reason creating the macros on this computer has caused it to run so slowly.

Everything is saved to my work's network drives. There is nothing to do with the documents (as far as I can tell) on the C:/ drive.

If it is something with the computer itself I can just have I.T. look at it, but I want to make sure its not something that the macros could somehow be causing.

 

[Jerry Sullivan]

A few things that might narrow down potential causes...

Do you have macros in your Personal.xlsb file that autorun when you open a workbook?

Do you have any Add-Ins installed?

Do you have plenty of available hard disk space? (even if your data is saved to the network, if you hard disk is nearly full your Apps will have to work harder to handle temporary files).

 

[RoryA]

Are you using Office 2003? If so, there's a recent Office File Validation update that causes severe performance issues - see this MSKB article.

 

[klarowe]

A few things that might narrow down potential causes...

Do you have macros in your Personal.xlsb file that autorun when you open a workbook?

Do you have any Add-Ins installed?

Do you have plenty of available hard disk space? (even if your data is saved to the network, if you hard disk is nearly full your Apps will have to work harder to handle temporary files).

I don't use a personal.xlsb for the codes. All codes are saved in each report.

As far as I know, no Add-Ins are installed.

I have 124GB of free space (out of 149GB) so there is plenty available.

Are you using Office 2003? If so, there's a recent Office File Validation update that causes severe performance issues - see this MSKB article.

I do have Office 2003 but so does every other computer and a few of the ones my department uses are newer than my laptop.

 

[RoryA]

It's a recent update - perhaps yours had it applied and theirs didn't?

 

[klarowe]

I'll have to have IT figure it out... I don't have the privilages to make the changes on that. Hopefully they can figure it out.

 

[klarowe]

Got it figured out. I brought the laptop to IT and they had no troubles what-so-ever so I knew it wasn't anything with the laptop. From there I checked my cables and sure enough my ethernet cable was shot. It was really weird because the internet worked fine and everything else seemed to work fine, but if I tried opening an Excel document from the network it was slow. And that was the only thing that was slow. But I replaced the cable and it solved the problem.

Def. a very odd one.