Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jul 2007
    Location
    United States
    Posts
    220
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linked Workbook Updates (2003)

    I have a workbook with a master table that is linked to 6 source workbooks with constituent tables. The distributed architecture afforded multi-user data entry without chancing data loss through sharing. I don't know if that is the most optimal way (I'd like to hear one if there is one), but it seems to work. However, without opening all workbooks at the same time to update the values on the master workbook is there an easier way that it will automatically update the values. Additionally, I want the formatting of the cells to update as well.

    The source workbooks have data validation, conditional formatting and formatting from VBA code that you helped me with. How do I need to set-up the master workbook so that the cells in the master table update upon opening with the most current values and formatting of the source books?

    Thanks.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Linked Workbook Updates (2003)

    Links to the source can update the values by opening and confirming that the links should be updated. The links will not capture any format changes. Formatting changes would have to be done via a macro of some sort.

    You could set up the same scheme (cond formatting and macros) in the destination as well as the source if desired.

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Jul 2007
    Location
    United States
    Posts
    220
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linked Workbook Updates (2003)

    I did set up the same scheme (cond formatting and macros) in the destination to match the sourcebooks; however, the formatting is not updating.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Linked Workbook Updates (2003)

    Could you attach a sample file which demonstrates the problem?

    Steve

  5. #5
    3 Star Lounger
    Join Date
    Jul 2007
    Location
    United States
    Posts
    220
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linked Workbook Updates (2003)

    Unfortunately not. The workbooks are stored on a non-transferrable, isolated network.

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Linked Workbook Updates (2003)

    You don't have to attach the actual file. Just recreate a sample that demonstrates the problem. You can populate it with dummy data.

    Steve

Posting Permissions

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