Capt. Computer Crasher, I just ran through your lesson. Very well put together. thank you!
I have some questions and would fee better to know if I am doing it right...
Can I recap for you what I am doing, and have you confirm that this is the best method?
- Create sheet set.
- Add existing sheets to sheet set.
- Rename/renumber sheets as required.
- Create block with fields for Current Sheet Number and Current Sheet Title in sheets.
- Create a data extraction with desired files.
- Extract data from Block containing Current Sheet Number and Current Sheet title
- Click "link external data" button to access dialogue box.
- Create dummy excel file.
- Fill in first column of dummy file with some/most of the Sheet Numbers
- Launch "Data Link Manager" to create data link.
- Select column of data extraction to mate up to external data column (where some/most of drawing numbers are typed up)
- Insert Data extraction table tinto drawing.
Here's what I think I figured out regarding updating the table with the changes to the Sheet Set List:
- Right-click the Sheet Set, and click save all sheets.
- Then update the data link?
This method seems to pull the data in the drawing which has been pushed out by the sheet set manager.
The excel file doesn't actually seem to update. Is this normal?
it's nothing more than a mule/dummy file?
Is there a way to make the Excel file push out data too?
Or is the Sheet Set Manager my only option?