Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linked data / formatting (2003)

    I'm sure I've seen this somewhere here, but I can't seem to find it.

    Anyway, what I'm trying to find out is how to retain the formatting (specifically conditional formatting) in a spreadsheet that's linked to another.

    The source data is updated from Access then the 'formatted' spreadsheet is opened, but it always drops the conditional formatting.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linked data / formatting (2003)

    So you have a sheet "A" that contains data that are updated from Access, and a sheet "B" that contains formulas that link to sheet "A". Is that correct, or did I misunderstand?

  3. #3
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linked data / formatting (2003)

    I didn't explain too well did I?

    Anyway, essentially you're correct, except they're 2 seperate files.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linked data / formatting (2003)

    Hmm, I can understand that the data that are updated directly from Access lose their formatting - the update essentially deletes all existing data then adds them from scratch.
    But in another workbook with formulas that link to the first one, formatting shouldn't be affected by updating the first workbook. I just tested that, and it confirmed my guess.
    Perhaps I still don't understand the setup...

  5. #5
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linked data / formatting (2003)

    Sorry mate, it's got well!

    There have been some network issues here that h ave thown some odd behaviours up, I guess this was just another one.

    Cheers.

Posting Permissions

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