unable to read file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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").
 
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.
 
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.
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error 0xC00D3E8E: The property is read only. One way to fix. 1
Unable to read file 4
Tracking Access in Read-Only Files 0
Importing and merging Excel files by using a macro 4
Unable to open .xls files saved by other users 1
"Unable to Read File" error message in Excel - solutions? 2
UNable to save excel files 1
Unable to Unprotect a 2003 .xls file 4

Back
Top