Linked Workbook Updates (2003)

Topic

New Reply

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.

Reply | Quote

Replies

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

Reply | Quote

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

Reply | Quote

Could you attach a sample file which demonstrates the problem?

Steve

Reply | Quote

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

Reply | Quote

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

Reply | Quote