Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Can only open Excel files on certain computers???

Posted on 2004-04-05
10
174 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
Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

 

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Bandwidth issues? 5 42
Remote access problem to camera controller 9 37
Cisco WRVS4400N 11 37
Home firewall recommendations 11 47
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
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…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

840 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