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.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Anna" wrote in message
...
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