File opening problem over network

  • Thread starter Thread starter Doug T
  • Start date Start date
D

Doug T

I have what seems to be a strange excel file opening issue that I can't
pinpoint and I would greatly appreciate any ideas to try for this problem.

We have a network computer running windows 98 SE. On this computer there
are many .xls files stored for users to access. Often when opening the
files users get an error that reads: Microsoft Excel cannot open or save any
more documents because there is not enough available memory or disk
pace. -To make more memory available, close workbooks or programs you no
longer need. -To free disk space, delete files you no longer need from the
disk you are saving to. The only option is to click OK, then excel is open
with no worksheets.

Here is what I know:
1. The problem is intermittent, although seems to happen more often
than not.
2. Only seems to happen on certain PCs, all running windows 2000, but
not all windwos 2000 PCs have the problem.
3. The PCs that this problem seems to happen with are the ones that
access these spreadsheets the most.
4. There is no problem if the files are opened by going to file, open
within excel.
5. Everything mentioned in the error message is not a problem on either
the users pc or the network one.
6. Most of the PCs that have the problem were upgraded from windows 98
and according to users the problem started after the upgrade (before my time
here). But not all of the PCs with the problem were upgrades, nor do all
that were upgraded have problems.

That is all I can think of for now. Again, any help would be greatly
appreciated. Thanks.
 
One more fact about the problem:

-If the files are moved to another PC, whether it is a different one on the
network, or the user's PC, there is no problem what so ever opening the
file.
 
I fixed a similar issue the other day. The user had
multiple wkbks open and got the same type errors. Office
2K has a memory limit that was resolved for this
particular issue with the installation of Office XP. It
solved a similar ongoing issue on 3 different systems
(Office 2K) regarding Excel and multiple wkbk opened.
hth
 
Seems like all PCs having trouble have windows 2000 SP 3 and that installing
SP 4 is the fix. Worked on one so far. See how it goes with the rest
tomorrow. thanks for the help.

DRT
 
Back
Top