Excel extremely slow opening

ChrisW · External Since: Mar 22, 2007 Posts: 6

Hi All,

We have one user on our domain who has a problem opening 2 excel
spreadsheets, in that they are extremely slow to open and save and close.
Using the spreadsheet once it has opened is fine its just when you come to
save it or close (even without saving) it takes about 4 or 5 minutes. The
excel files are both less than 500KB. The PC is not the fastest machine ever
but its certainly not that bad, and can open other excel documents fine. If
the user logs onto another PC, they do not have the problem though. The files
are located on a network drive and when i copy them to the local drive, they
work fine. However, the user can open other spreadsheets from that very same
network drive directory without a problem. It is a shared workbook but no
other users have any problems. I have turned off things like automatically
calculate and check external file references, and i have removed all temp
files. Really out of ideas, any suggestions?

Anne Troy · External Since: Jun 19, 2005 Posts: 3716

This sounds suspiciously to me like there is some kind of temp file(s) on
the network. Have you checked? But, just to be sure, I would troubleshoot
their Excel...perhaps there's a file in their XLSTART or something that's
interfering...
http://www.officearticles.com/excel/troubleshooting_microsoft_excel.htm
Or perhaps there's something weird with the workbook:
http://www.officearticles.com/excel/troubleshoot_your_workbook_in_micr...ft_exce
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"ChrisW (MCP)" <ChrisWMCP RemoveThis @discussions.microsoft.com> wrote in message
news:98D66E38-9009-44DD-926F-2DD0C66E0F10@microsoft.com...
> Hi All,
>
> We have one user on our domain who has a problem opening 2 excel
> spreadsheets, in that they are extremely slow to open and save and close.
> Using the spreadsheet once it has opened is fine its just when you come to
> save it or close (even without saving) it takes about 4 or 5 minutes. The
> excel files are both less than 500KB. The PC is not the fastest machine
> ever
> but its certainly not that bad, and can open other excel documents fine.
> If
> the user logs onto another PC, they do not have the problem though. The
> files
> are located on a network drive and when i copy them to the local drive,
> they
> work fine. However, the user can open other spreadsheets from that very
> same
> network drive directory without a problem. It is a shared workbook but no
> other users have any problems. I have turned off things like automatically
> calculate and check external file references, and i have removed all temp
> files. Really out of ideas, any suggestions?

ChrisW · External Since: Mar 22, 2007 Posts: 6

where would i check for temp files on the network? also, it is only this
machine thats having the problem, surely if the temp files are on the network
then every machine would have the problem? nothing in the xlstart and ive
completely re-installed office. no change

"Anne Troy" wrote:

> This sounds suspiciously to me like there is some kind of temp file(s) on
> the network. Have you checked? But, just to be sure, I would troubleshoot
> their Excel...perhaps there's a file in their XLSTART or something that's
> interfering...
> http://www.officearticles.com/excel/troubleshooting_microsoft_excel.htm
> Or perhaps there's something weird with the workbook:
> http://www.officearticles.com/excel/troubleshoot_your_workbook_in_micr...ft_exce
> ****************************
> Hope it helps!
> Anne Troy
> www.OfficeArticles.com
> ****************************
> "ChrisW (MCP)" <ChrisWMCP.DeleteThis@discussions.microsoft.com> wrote in message
> news:98D66E38-9009-44DD-926F-2DD0C66E0F10@microsoft.com...
> > Hi All,
> >
> > We have one user on our domain who has a problem opening 2 excel
> > spreadsheets, in that they are extremely slow to open and save and close.
> > Using the spreadsheet once it has opened is fine its just when you come to
> > save it or close (even without saving) it takes about 4 or 5 minutes. The
> > excel files are both less than 500KB. The PC is not the fastest machine
> > ever
> > but its certainly not that bad, and can open other excel documents fine.
> > If
> > the user logs onto another PC, they do not have the problem though. The
> > files
> > are located on a network drive and when i copy them to the local drive,
> > they
> > work fine. However, the user can open other spreadsheets from that very
> > same
> > network drive directory without a problem. It is a shared workbook but no
> > other users have any problems. I have turned off things like automatically
> > calculate and check external file references, and i have removed all temp
> > files. Really out of ideas, any suggestions?
>
>
>

andym · Joined: May 14, 2007 Posts: 1

hi all, first post for me on the forum.

did this one ever get solved? - i have exactly the same problem and am struggling to find a solution at the moment.

thanks

stevero · Joined: Aug 02, 2007 Posts: 5

I had the same problem on a new HP laptop with Vista Business and a whole bunch of HP crapware loaded, including Norton Antivirus. There is much said on the web how Norton can cause slow loading of Word and Excel files. Since I have another antivirus program I use, I disabled Norton from loading in msconfig. Still had painfully slow Office loads.

As a hope and a prayer, I totally uninstalled Norton, and now Office aps loads like they should. I'm not sure what was happening, but I'm guessing opening an Office ap must have somehow caused Norton to load, or at least tried to cause Norton to load. Get rid of Norton Antivirus and get something else that plays nice with MS Office.

freeload101 · Joined: Oct 19, 2005 Posts: 2

m3Rlin · Joined: Mar 27, 2008 Posts: 1

This article may help: http://www.m3rlin.org/wordpress/slow-opening-excel-2003-files-in-excel-2007/

zax20 · Joined: Apr 18, 2008 Posts: 1

May be, This blog will be helpful

http://excel2007-slow-open-file.blogspot.com/