Share via

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

Anonymous
2012-05-09T10:35:03+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2012-05-10T01:40:01+00:00

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.

Was this answer helpful?

0 comments No comments

0 additional answers

Sort by: Most helpful