Solved

Can only open Excel files on certain computers???

Posted on 2004-04-05
10
175 Views
Last Modified: 2012-05-04
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
0
Comment
Question by:rickpary
  • 4
  • 2
  • 2
  • +2
10 Comments
 
LVL 27

Expert Comment

by:pseudocyber
ID: 10757764
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
 

Author Comment

by:rickpary
ID: 10757856
No, as I stated in question they are not short cuts. They are the actual files . . .
0
 
LVL 27

Expert Comment

by:pseudocyber
ID: 10757909
Oops.  Sorry, missed that in your original.
0
Save the day with this special offer from ATEN!

Save 30% on the CV211 using promo code EXPERTS30 now through April 30th. The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

 

Author Comment

by:rickpary
ID: 10757927
lol, no problem
its driving me nuts!
0
 
LVL 12

Expert Comment

by:RWrigley
ID: 10758050
Does the laptop have Offline Files turned on?
0
 

Author Comment

by:rickpary
ID: 10758080
Not sure. It is at a clients. Will check. Would that cause that problem?
How do you turn on offline files?
0
 

Expert Comment

by:Hermoinee
ID: 10762064
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
 
LVL 3

Expert Comment

by:shaggyb
ID: 10763158
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
 
LVL 12

Accepted Solution

by:
RWrigley earned 500 total points
ID: 10764808
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
 

Author Comment

by:rickpary
ID: 10998772
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

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Short answer to this question: there is no effective WiFi manager in iOS devices as seen in Windows WiFi or Macbook OSx WiFi management, but this article will try and provide some amicable solutions to better suite your needs.
Let’s list some of the technologies that enable smooth teleworking. 
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question