Excel XML mapping hyperlink cell - only text exported, need all hyperlink too

Question

Hi,

I am using the XML export / import.

One of the problems is a cell with a hyperlink in it - in this case to a cell on another sheet.

When the cell is exported only the text is present - not the underlying hyperlink.

So, of course, when the XML data is imported into an empty spreadsheet, only the text is there, the hyperlink is lost.

Is the XSD file supposed to map this type of data? In which case, what should it be?

Any ideas gratefully received.

Many thanks,

john

Answer 1

Unfortunately nothing can be done, as the data exported in XML format will not retain hyperlinks or formulas as the structure of the data file itself changes when exported in XML format from the default format.