View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
KC Rippstein hotmail com> KC Rippstein hotmail com> is offline
external usenet poster
 
Posts: 168
Default unable to read file

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

--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Anna" wrote:

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