- Linking Excel and CADVANCE
We suggest that prior to creating your first link to Excel that you check out the
example in the Bonus Book that came with CADVANCE. Then, follow the tutorial on this
process which is in the TECHNOTE.WRI file located in the CADVANCE directory. Not wanting
to reproduce that entire document here, the following is a specific list of tips to avoid
problems placing linked Excel tables in a CADVANCE drawing:
Open Excel and CADVANCE. Close everything else.
Open only the two documents being used in the link. Don't open multiple drawings or
multiple Excel spreadsheets. This will maximize the available Windows resources for use in
the linking process and insure the most reliable results. (unless you're using Windows95:
Microsoft minimized any resource problem you may encounter with OLE)
Set your CADVANCE Options/Colors to black on white with color 3, the highlight color,
set to red. If you leave the typical color mapping, with black as the background color, it
results in an invisible Excel link in your CADVANCE drawing. You can't see black text on a
Format your Excel documents in multiples of 8 ½" x 11" pages for linking.
For example if you have a very long table in Excel you wish to bring into CADVANCE, do it
in multiple paste/links of 8 ½ x 11 pages rather than trying to paste the whole document
at once. Maximize the page size by minimizing the margins to 1/4". Eliminate headers
and footers. Do not try linking larger areas or the odds are good that errors will occur.
Make no more than three links to a CADVANCE
document during one CADVANCE session.
Otherwise you'll run out of resources and receive a General Protection Fault. Don't be
alarmed by this limitation. It reflects a limitation imposed by Windows resources.
Microsoft didn't envision us making 30 links to our CAD drawings. (If you're running
Windows95 this limitation does not exist: Users have made 30 links in one session without
a problem, under this new and improved version of Windows.)
Save your drawing after each and every link.
Made a mistake? No problem, just delete the link and File/Pack your drawing before
making additional links. Packing removes information from the drawing file, not just the
If you're using a pen plotter driver, use one of the Windows vector fonts, Modern,
Roman, or Script to format your Excel table. Use the Excel border lines instead of the
default grids, as grids will not plot with a pen plotter driver (WIN907).
Use raster output devices whenever possible for better formatting control (one user
with a Calcomp E-stat plotter uses the CCRF driver because it will print WYSIWYG - what
you see is what you get). Don't use TT text in the same file, or the Excel object will
loose it's formatting (we're looking for a fix to this problem in 7.0).
Use linking instead of embedding. This will allow the project architect, manager, or
job captain to edit the table without having access to CADVANCE. If you embed the Excel
sheet in CADVANCE the only way to access it is thru CADVANCE. The table will not exist as
a separate file on disk! Please make an extra note of this. Often a table starts as an
Excel file. If it is then later embedded into a CADVANCE working drawing by mistake, when
changes are made to the original Excel file, they will not be updated in CADVANCE. The
only way to update an embedded Excel table is to first start CADVANCE and then double
click on the table. The embedded table will be loaded automatically in Excel for editing.