In the last few years I have noticed that some techs and engineers insert storm tables, created in excel, as PDF files or even do a copy and past into their drawings. I am sure some of you do the paste special option and select AutoCAD entities or Microsoft chart option.
Tonight I will show you another way to insert excel tables with the data link command. If you type the command DATALINK the data link manager will appear.
Click on the “Create new excel sheet” and small dialog box will appear asking you for a data link name. I typically provide the project number then the table name such Prop Storm or Ex Storm.
BE SURE TO TURN OFF YOUR PREVIEW
The New Excel Data Link dialog box will appear. You will first browse to your excel sheet. Then select the sheet or tab that you want to use . !. The reason I say this is because it has a tendency to bog down when trying to display your table in a small preview area.
Next select the area that you want to insert. I have provided a short video presentation on how to insert the able that you just create. The data link command will definitely be a helpful way to add storm and drainage area tables into you plans. I hope this information will be help improve production time.