How to link cells bet. wkshts in excel so that formats r also link

G

Guest

I currently have linked the cells between wksheet in excel 2000. However the
paste link function do not allowed cell format to be linked as well. Is there
anyway to overcome this? Eg, when i change the text in master cell to blue,
the cell linked to the master cell are not linked to reflect the blue text.
 
T

Thomas A. Rowe

For the best support, you need to post this to the Excel newsgroup.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================
 
A

Andrew Murray

This is not a Frontpage question....is it?

You should try the Excel newsgroup.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I link data between worksheets when data is transposed? 3
Excel Changing chart label colors based on a value in a cell 0
pasting linked excel cell and maintaining formatting no matter wha 1
pasting linked cell from Exc and maintaining formatting no matter 5
Help, linking doesn't copy over the text format??? 2
Linked Charts in PPT 2007 2
How to get an autoshape to have same format as its linked cell? 1
keeping text format in linked cells 1

Top