Cell formatting lost when a hyperlink is added

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.

Jim wrote:
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

=?Utf-8?B?Smlt?= wrote in
:

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?