Cell formatting lost when a hyperlink is added

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim - 29 Oct 2004 11:18 GMT

I spent a lot of time formatting a page to be just the way I wanted it. Then
when I went to set up the hyperlinks to the data pages, the cell formatting
goes away, font size etc...
Is there a way to hyperlink without losing your formatting. I don't want to
go back and re do it.

Reply to this Message

Bill Manville - 29 Oct 2004 12:43 GMT

> I spent a lot of time formatting a page to be just the way I wanted it. Then
> when I went to set up the hyperlinks to the data pages, the cell formatting
> goes away, font size etc...

Is your hyperlink addressing the old version instead of the new?
In what application are the hyperlinks you are clicking?
When you click on the hyperlink what application is the file being opened in?

If you were talking about Excel formula links rather than hyperlinks then
certainly formatting does not get copied across the link, only values.
If you are using the same layout on the source sheet and the destination you
could copy the source data and Edit / paste special / formats on the destination
data. Or you could copy a picture of the source if you don't need the cells in
the destination to take part in any formulas.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message

ch - 29 Oct 2004 21:39 GMT

> I spent a lot of time formatting a page to be just the way I
> wanted it. Then when I went to set up the hyperlinks to the data
> pages, the cell formatting goes away, font size etc...
> Is there a way to hyperlink without losing your formatting. I
> don't want to go back and re do it.

Maybe change the style for hyperlink and followed hyperlink to
be identical to your normal style?

Reply to this Message