Posted by Grant on October 19, 2000 1:04 PM
What would you do in this scenario:
You have multiple workbooks that contain detail information. You also have a summary workbook that links back to the detail pages to pull values. The summary workbook is synchronized with a PDA device running Pocket Excel. This summary workbook is basically only used on the PDA and is rarely opened in Excel.
How do you get the linked information to update in the summary workbook when something is changed in one of the other workbooks without opening the summary in Excel and refreshing the links? The process should be automatic and transparent to the user, so that whenever the summary file is synchronized, it always has the most up-to-date information.