ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Unable to reference data stored in XML spreadsheets (https://www.excelbanter.com/excel-programming/315805-unable-reference-data-stored-xml-spreadsheets.html)

[email protected]

Unable to reference data stored in XML spreadsheets
 
Does anyone know if it's possible to have a link referencing data
stored in XML spreadsheets?

For example, if a link, such as
='C:\My Documents\Worksheets\[2005 Budget.xml]Details'!$R$10, is
referencing a XML spreadsheet, Excel 2002 would display an error
message indicating the link can not be updated.

The only way to make this link work is to open the XML spreadsheet in
Excel also.

Any information would be appreciated.
Thanks.



All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com