Re: Excel opens files very slowly

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Don Guillett (donaldb_at_281.com)
Date: 01/03/05 

Date: Mon, 3 Jan 2005 10:13:55 -0600

a google search for slow opening yielded:
http://tinyurl.com/4lsws 

-- 
Don Guillett
SalesAid Software
donaldb@281.com
"jeparham" <jeparham@santeecooper.com> wrote in message
news:OY1uQqa8EHA.2452@TK2MSFTNGP14.phx.gbl...
> I have an odd problem that is driving me nuts.
>
> Computer 1 has no problems with Excel
>
> Computer 2 has no problems with Excel
>
> Computer 3 is my problem.  It opens all files, XLS, DBF, etc, extremely
> slow.
>
> I tried a test on a files named "Results.xls".  The file is on a local
drive
> of Computer 3 and is 38kb in size.  It has no macros, no links, no
filters,
> nothing.  It's a simple spreadsheet consisting of 10C x 35R of data.
>
> There are no Add-ins loaded on any of the three PCs, nor is there a
> Personal.xls file loaded on any of them.
>
> I opened the same file one computer at a time on all three computers.
> Computers 1 and 2 opened the file, across my network, in less than 5
> seconds.
>
> Computer 3, which is where the test file was located, took 50+ seconds to
> open the file.
>
> I have these PCs isolated behind a hardware and a software firewall, and
> each PC is running current AV software.
>
> Does anyone have any suggestions as to what I might try to fix this
problem?
>
> Thanks,
>
> James
>
>

Relevant Pages

  • Excel opens files very slowly
    ... Computer 1 has no problems with Excel ... It opens all files, XLS, DBF, etc, extremely ... Computer 3, which is where the test file was located, took 50+ seconds to ... I have these PCs isolated behind a hardware and a software firewall, ...
    (microsoft.public.excel)
  • Re: Check File Open Macro
    ... Dim oXL As Object 'This is needed to open a new instance of Excel. ... 'THIS LINE OF CODE OPENS THE NEW INSTANCE OF EXCEL. ... Internet, To Do Lists, Travel Tickets & Hotel Reservations and THE LIST ...
    (microsoft.public.excel.programming)
  • Re: Excel - Not calculating formulas
    ... Once calculation is set to automatic or manual (this mode is set by the first ... workbook you open in that session), then that calculation mode will stay this ... excel is still set in automatic mode. ... It takes the Option from the first file it opens. ...
    (microsoft.public.excel.misc)
  • Spreadsheet shortcuts not working
    ... We have shortcuts to spreadsheets setup but when we click on them excel comes ... up but the spreadsheet does not load and there are no error messages. ... But when the speadsheet opens it gives errors that it can not find ... Workstation O24 can not open excel spreadsheets using shortcuts. ...
    (microsoft.public.excel.setup)
  • Re: Using personal.xls in two windows
    ... If that doesn't work for you, then you could mark the personal.xls file as ReadOnly (using windows Explorer). ... You'll have to remove that readonly mark, make your changes in excel, save the workbook, and then mark it as ReadOnly. ... If I open excel book 1, then c/o New, it opens book 2 but on taskbar only. ...
    (microsoft.public.excel.misc)