Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forced Refresh on a Linked Sheet
We are an engineering firm that frequently links Excel
spreadsheets to AutoCad. When AutoCad opens a drawing file that has an Excel link it automatically checks the Excel file for any updates. The AutoCad drawing stays in sync with the Excel file and it works great! However, we need to do this in a more complex manner: We need to create: a) a Master spreadsheet that contains all information regarding a project and frequently has new rows added, b) various linked spreadsheets that take the data from the Master and sort/filter it based on various criteria (e.g., column A= T or column A=DI), c) link the linked/sorted/filtered spreadhseet to AutoCad. So, the issue becomes this: how can we force the worksheet linked to AutoCad to automatically refresh itself each time it is opened? How can we guarantee that the sort/filter contains all of the latest data? Thank you for your time. This forum is invaluable to us here. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic refresh in linked worksheet if row is added | Excel Worksheet Functions | |||
Refresh all but 1st sheet | Charts and Charting in Excel | |||
Refresh linked data | Excel Worksheet Functions | |||
Auto Refresh evey ?? in a linked list | Excel Discussion (Misc queries) | |||
Transfer/Copy Sheet, Dynamically linked Sheet | Excel Discussion (Misc queries) |