unable to read file

A

Anna

We have a file put it under intranet. I can search the xls file and when I
open it it prompts 'unable to read file'. I copy it to my PC and run. It
comes out with the same message.
Note: It can be found under search file. The modified date and file size can
be seen.
It is a macro file that running the update of Privot table.
Thank you for anyone that can help me
 
K

KC Rippstein hotmail com>

It sounds like the file extension has been altered. When you use MyComputer
and go to the place where the file is stored, is the icon by the filename an
Excel icon? If the file name ends with .xls it should recognize it as an
Excel file. You may need to change your view to see the file extensions (so
in MyComputer, go to Tools->Folder Options->View and uncheck the box for
"Hide extensions for known file types").
 
K

KC Rippstein hotmail com>

Perhaps your macro cannot find the file? You have to be very specific in the
macro about where the file is located, so make sure the macro is being
directed to the right location on your PC or network.
 
E

Earl Kiosterud

Anna,

One possibility is that someone opened it with Word, then saved it. Word
saves it as a Word document, which it now is, but with the original name and
..xls extension, overwriting your Excel file forever. You're saying "Nooooo.
It would never do that." It does. See if Word can open it. You'll still
have lost all the Excel functionality (formulas, etc). This problem has
been around since WOrd 97. No one hears your screams.
 
A

Anna

thank you. your are correct

Earl Kiosterud said:
Anna,

One possibility is that someone opened it with Word, then saved it. Word
saves it as a Word document, which it now is, but with the original name and
..xls extension, overwriting your Excel file forever. You're saying "Nooooo.
It would never do that." It does. See if Word can open it. You'll still
have lost all the Excel functionality (formulas, etc). This problem has
been around since WOrd 97. No one hears your screams.
Click to expand...
 
Top