HELP!!!! Excell Cut and Paste Special (OLE Objects)

[Mark Chapman]

Hello and I hope someone can help!!

I have an Excell Spreadsheet containing electrical panel schedule I would
love to import into ACAD
as an OLE Object such that changes made by our engineers will automatically
update the drawing itself.

UNFORTUNATELY:" Excell spreadsheets pasted into AutoCAD use only the Picture
(metafile) format. If a spreadsheet is too large, only part of it is pasted
into the drawing" ACADr14 users guide pp 666.

IS THERE ANYWAY this limitation can be overcome??? ]

Is this a GATES problem, or .......

Thanks, speedy replies welcome

Mark Chapman

[William H. Geiger]

Mark,

What do you mean by too large?

I am able to link one typical sized panel schedule, by scaling using
the grips.

If "to large", link as two separate tables, instead of one from the
same sheet.

Recommend storing the drawing and spreadsheet in the same
sub-directory and root file name (except extension) as they become
Siamese twins.

Need more help? Come back.

Regards,

WHG

[Mark Chapman]

William-

The spreadsheet in question is approximately 26 cols wide (c-ac) and 37
rows.
It seems to cut off the colums beginning at ab.

I have tried cutting and pasting smaller sections and while this may be an
intermediate solution it is certainly a difficult workaround.

Would you know if this is an MS limitation or Adsk?

Thanks,

Mark Chapman

William H. Geiger wrote in message <363a7078....@100.100.100.1>...

[JohnB]

Is it cutting off the schedule at the page break? I've had that problem, try
manually removing or changing the page break.
....good luck!

Mark Chapman wrote in message <71de7g$oa...@adesknews2.autodesk.com>...

[Colin Smyth]

Mark,

I have been having the same difficulties. The following may explain the
problem but I cannot provide a fix. If you find one - please let me know.

Extract from "Application and Installation Issues [readme]" in AutoCAD R14
help.

AutoCAD and Microsoft Excel

A common problem encountered when pasting spreadsheets into AutoCAD is that
large sheets are sometimes truncated. Microsoft Excel limits the size of its
metafiles on the clipboard to 12 1/2 inches. This limitation is based on
spreadsheet size, not number of rows or columns. To work around this
problem, reduce row height and/or column width, and font. Another workaround
is to choose Paste Special from the AutoCAD Edit menu and select Image
Entity.

(Paste Special, Image Entity image entity did not work for me - you may have
more luck)

Colin Smyth

[Jeff Lanctot [Autodesk Product Support]]

Mark,

This is an importation limitation of AutoCAD, there is no way around it
short of using a 3rd party utility, or doing multiple cuts and pastes.

Sorry,
--
Jeff Lanctot
EPS Product Support, US
WW Support & Services, Autodesk
Discussion Q&A: http://www.autodesk.com/discussion
Mark Chapman wrote in message <71ko3u$45...@adesknews2.autodesk.com>...

[ma...@compel.net]

To all who responed---

Thanks for all your comments and suggestions.
In the final analysis, I have located a nifty "shareware" utility called
'SPANNER' which exports all or selected
cells (with formatting/borders etc maintained). The resulting file is then
imported into ACAD thru its own dialogue for updates if required.

The advantage to this is that DWF files contain this information whereas OLE
objects are not included in the resulting DWF.

VOILA

Thanks again for the help!!!

Mark Chapman