Workbook linking with formatting.

Johnromita · Apr 29th, 2002, 07:13 AM

Hi, can anybody help me out?
I have several different workbooks, I want to create a new one which displays certain stats from the others. I've tried linking the source straight from the dependent, but all the formatting (merged cells and colours) is lost when this happens. The data is basically a calender, with merged cells indicating promotions over a period of time. As such, it's vital to keep the formatting as I compare the data in the new sheet. (I'm using the "paste special" "paste link" command. (Excel 2000)
Thanks in advance,
John.

Johnromita · Apr 29th, 2002, 08:17 AM

I assume that there is no way of doing this then?

Johnromita · Apr 29th, 2002, 09:36 AM

Is there absolutely no way of doing this? I just want the formatting to be picked up in the link. Please Mr. Excel, help meeeeeeeeeeeeeeeeee!!!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 07:13 AM	#1
Johnromita New Member Join Date: Apr 2002 Posts: 3	Hi, can anybody help me out? I have several different workbooks, I want to create a new one which displays certain stats from the others. I've tried linking the source straight from the dependent, but all the formatting (merged cells and colours) is lost when this happens. The data is basically a calender, with merged cells indicating promotions over a period of time. As such, it's vital to keep the formatting as I compare the data in the new sheet. (I'm using the "paste special" "paste link" command. (Excel 2000) Thanks in advance, John.

Apr 29th, 2002, 08:17 AM	#2
Johnromita New Member Join Date: Apr 2002 Posts: 3	I assume that there is no way of doing this then?

Apr 29th, 2002, 09:36 AM	#3
Johnromita New Member Join Date: Apr 2002 Posts: 3	Is there absolutely no way of doing this? I just want the formatting to be picked up in the link. Please Mr. Excel, help meeeeeeeeeeeeeeeeee!!!!!