H
Hassan
Using Excel 2003. I created a chart off of a pivot table 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
the charting area but the data is not present. Gives error below in the
pivot table that appears.
The query could not be processed:
o Error opening data file
"file://\\remoteserver01\hassan\numbers_files\Numbers_Jan24_12558_cachedata001.xml".
Any idea how to fix it ? I want others to access it remotely.
Is there something in the htm file that I need to edit to make it point to
the right xml file. I dont think its permissions and I can edit the file,add
files,etc..
Thanks
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
the charting area but the data is not present. Gives error below in the
pivot table that appears.
The query could not be processed:
o Error opening data file
"file://\\remoteserver01\hassan\numbers_files\Numbers_Jan24_12558_cachedata001.xml".
Any idea how to fix it ? I want others to access it remotely.
Is there something in the htm file that I need to edit to make it point to
the right xml file. I dont think its permissions and I can edit the file,add
files,etc..
Thanks