Import Excel spreadsheet and Word text into AutoCAD and MicroStation

Home

Free Trial

New Release

Fast Facts

Order

Tutorial

Support Forum

FAQ

Contact

Partner Links




 


 

Tutorial >> Update imported spreadsheet
Step 1

Make some changes to the Excel file which has been imported into ACAD.

Make sure to save your changes in Excel before switching to ACAD for update.

Step 2
Click on CADTool >> Update All Tables  from pull down menu
Step 3
All imported schedules in ACAD will get updated. Update status log file shows up in ACAD command line window

To save update time, Office2CAD ignores Excel files which have no change and only update those files modified since last import/update.

Office2CAD judges if an Excel file is changed or not based on the file's time stamp. Each time you save an Excel file, the file's time stamp will be updated to current time.

Auto-update feature when drawing is open

Each time when a drawing containing imported tables is open, all imported tables will be automatically updated.

Some users may find this auto-update feature is annoying if they have 10 imported tables in their drawing and have only one table changed, or even no table changed.

To solve this problem, users can click on  CADTool >> Turn Auto-Update On/Off  to disable the auto-update feature. 

 

Two update options

 

User can

Click on CADTool >> Update Selected Table  to pick a changed table for update

Click on CADTool >> Update All Tables to force an update for all tables

 

To save update time
  • If you have 10 tables coming from 10 different Excel files, Update All  Tables will be the best choice as it will only update the file which is modified based on its time stamp

  • If you have 10 tables coming from 10 different sheets containing in a single Excel file, Update Selected Table will be the best choice as the time stamp decision does not work for this scenario

  • Save Excel file only when you make changes on it. Do NOT save if you make no change, otherwise it will trigger Office2CAD to update the imported table

  • To force an update, you must save the Excel file, otherwise it will be ignored during the update.

Please check out next tutorial   Spreadsheets imported with greater symbology precision and flexibility 

Go Top

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

autocad excel  excel autocad  autocad excel link  autocad office  autocad table  table autocad  office cad  autocad vba  cad excel  excel cad  excel to autocad

autocad excel  excel autocad  autocad excel link  autocad office  autocad table  table autocad  office cad  autocad vba  cad excel  excel cad  excel to autocad

autocad excel  excel autocad  autocad excel link  autocad office  autocad table  table autocad  office cad  autocad vba  cad excel  excel cad  excel to autocad