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

--
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

The file showing excel format. When I double click, excel program will run
auto.

"KC Rippstein" wrote:

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

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.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Anna" wrote:

The file showing excel format. When I double click, excel program will run
auto.

"KC Rippstein" wrote:

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

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

thank you. your are correct

"Earl Kiosterud" wrote:

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