Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Workbook linking with formatting.

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  2. #2
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!!!!!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •