excel 2003 publish to a remote share does not work...
 

Using Excel 2003. Create a chart and have saved it as a web page and
published to a remote share.

When I save it locally, it works fine and is interactive,etc..

When I save it remotely and open the htm file in a web browser, it opens
like the charting area but the data is not present. Gives error below in the
pivot table that appears.

Getting error

The query could not be processed:
o Error opening data file
"file://\\remoteserver01\hassan\numbers_files\Numbers_Jan2 4_12558_cachedata001.xml".

Any idea how to fix it ? I want others to access it remotely.

Thanks