I have a question along these lines....

My issue is that if the source data formatting is changed, the change in the
formatting isn't reflected in the link on the destination worksheet.

For example: I have a link in cell A1 in Tab1 pointing to A1 in Tab2 which
starts by being a dollar amount ($1,000). If I change A1 in Tab 2 to a
percent and change it's formatting to (.50%), the link in Tab 1 stays a
dollar amount ($0.50).

How can I make the link match the new formatting of its source?

I would appreciate any help you can provide.

Thank you,

--
Suzanne Marie


"Dave Peterson" wrote:

I don't use xl2003 (I use xl2002), but I could do:

Edit|copy
edit|paste special|paste link
followed immediately by
edit|paste special|formats

And it worked the same way in reverse:

Edit|copy
edit|paste special|formats
followed immediately by
edit|paste special|paste link

My first guess is that xl2003 didn't change, but rather you have some event
macro running (worksheet_activate, worksheet_selectionchange, ....) that's
killing the clipboard.

If you open your workbook with macros disabled, can you do your copy|paste
specials (both of them)???



Richard wrote:

I'm trying to paste a range of cells from sheet1 to sheet2 using Paste
Special Paste Link but I can't retain the formatting from sheet1. If I
don't link, then no problem - I can select 'ALL' after Paste Special, but
then Excel can't find the values!

I'm using Excel 2003. Any takers?
--
Thanks,

Richard S.

--

Dave Peterson

Formulas return values--not formats.

If you're lucky, you might be able to mimic the formatting change via
Format|conditional formatting.

(say if Yes is always manually shaded Green and No is always shaded Red--but
that doesn't always help.)

Suzanne Marie wrote:

I have a question along these lines....

My issue is that if the source data formatting is changed, the change in the
formatting isn't reflected in the link on the destination worksheet.

For example: I have a link in cell A1 in Tab1 pointing to A1 in Tab2 which
starts by being a dollar amount ($1,000). If I change A1 in Tab 2 to a
percent and change it's formatting to (.50%), the link in Tab 1 stays a
dollar amount ($0.50).

How can I make the link match the new formatting of its source?

I would appreciate any help you can provide.

Thank you,

--
Suzanne Marie

"Dave Peterson" wrote:

I don't use xl2003 (I use xl2002), but I could do:

Edit|copy
edit|paste special|paste link
followed immediately by
edit|paste special|formats

And it worked the same way in reverse:

Edit|copy
edit|paste special|formats
followed immediately by
edit|paste special|paste link

My first guess is that xl2003 didn't change, but rather you have some event
macro running (worksheet_activate, worksheet_selectionchange, ....) that's
killing the clipboard.

If you open your workbook with macros disabled, can you do your copy|paste
specials (both of them)???



Richard wrote:

I'm trying to paste a range of cells from sheet1 to sheet2 using Paste
Special Paste Link but I can't retain the formatting from sheet1. If I
don't link, then no problem - I can select 'ALL' after Paste Special, but
then Excel can't find the values!

I'm using Excel 2003. Any takers?
--
Thanks,

Richard S.

--

Dave Peterson



--

Dave Peterson