Can only open Excel files on certain computers???

I just set up a Linksys wireless network:
Desktop computer running Windows 98
Laptop running Windows XP Home

After installing the wireless LAN I now experience the following problem:
Microsoft Excel when trying to open certain files on the laptop will only
open them when on the LAN and the desktop I "COPIED" them from is turned on
( these are not shortcuts but files actually copied ).  Both machines are
using MS Office 2000, if I copy the files to a floppy disk I can open them
on other machines not connected to the LAN, turn off the desktop and the
laptop will not even open the files on the floppy ( I get one of those nice
MS XP messages asking me if I want to send an error report then Excel shuts
down ).  If I create a new file on the laptop and save it, the new file will
open just fine when not on the LAN.

Could this be a permissions issue?  It doesn't seem possible considering it
is on a workgroup and the operating systems are not really set up for
security.
Thanks
rickparyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
RWrigleyConnect With a Mentor Commented:
Another possibility is that the excel file contains an embedded object that doesn't exist or is of a different version on yourlaptop (which would explain the exception error your getting).  Have you updated the Office installation on the laptop (DAO objects and stuff)?
0
 
pseudocyberCommented:
Could Excel be trying to open the file from the desktop?  Like if you copied a shortcut pointing back to the file on the desktop instead of copying the file itself?
0
 
rickparyAuthor Commented:
No, as I stated in question they are not short cuts. They are the actual files . . .
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
pseudocyberCommented:
Oops.  Sorry, missed that in your original.
0
 
rickparyAuthor Commented:
lol, no problem
its driving me nuts!
0
 
RWrigleyCommented:
Does the laptop have Offline Files turned on?
0
 
rickparyAuthor Commented:
Not sure. It is at a clients. Will check. Would that cause that problem?
How do you turn on offline files?
0
 
HermoineeCommented:
hi
 well to turn on the offline files go to tools-> folder options of windows. u can find this option whenever u open a dir or a folder in a dir. check them up !! u have an option there as place shortcuts to offline files or folders in desktop. hope this helps u !
                                                                 
0
 
shaggybCommented:
you dont suppose there is a refference in one or more cells to get a value for a computation from another workbook that IS still on the desktop?
0
 
rickparyAuthor Commented:
Well, none of that fixed it. I had to create a user that the files were originally with on the other computers & that was the trick. Don't quite understand it but it worked . . .
Thanks anyways . . .
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.