synchronized connection between excel and autocad cells

[reggio]

Hello everyone, good year.

I have difficulty connecting some cells of a sheet/file of excel with autocad2011, I did some tests that leave me puzzled:

I open the desired excel file and take me into the desired worksheet, select for example from b35 to d39, copy and take off in autocad
Now on excel, cell d39 I add some characters that I expect to find in autocad, but so it is not, it seems not to be synchronized

I try with double click (even triple or quadruple ...) on the table copied in autocad and I see opening another excel sheet that is not the original,
if I now go to d39 and add changes and save this other excel sheet (only save, not save by name) here is that the changes are also reported on autocad (live!), if I then make other changes, now it does not even need to save and the changes are immediately transferred to autocad (yeppi to yeah!) ...

sin that if except the other excel sheet, the original one does not change and does not memorize any changes :frown:
if I change original excel, in autocad nothing changes
If, except for autocad, the connection remains with the other excel sheet

if then, as it serves to me, select another area of excel (original) b20-d22 and take off on autocad, clicking on this new table in autocad, I will open a new copy of the excel sheet, disconnected both from the original and from the other copy mentioned above...

In short, it seems that every time you paste a group of cells on autocad, this is connected with a "fantasm" excel sheet disconnected with the original and with the other ghost sheets, making everything useless ...:frown:
I ask you, is there any way to really connect and sync some excel cells with autocad2011? explain how?

 

[Tristan]

Are you using ole objects?
test with this methodhttp://ctrl-alt-cad.blogspot.it/2010/04/collegamenti-dati-ms-excel.html

 

[GP.]

...is there any way to actually connect and sync some excel cells with autocad2011? . . .

the answer is yes, but the procedures are different according to the choice to operate on an external .xls file or on one from incorporare in the dwg:
xls external file- in the excel file "Saved with name" (*) select the range of cells to paste
- in autocad pastespec -> paste link -> microsoft excel worksheet (code)
changes made to the table in autocad by opening the .xls (double/triple/quadruple click) can be saved in .xls original.
changes to the .xls file original will be reflected on the table in autocad.
file xls incorporato- in the unsaved excel file (**) select the range of cells to paste
- in autocad pasteclip
changes made to the autocad table by opening the .xls (double/triple/quadruple click) will be saved in .xls Built-in, which is created with the bonding operation.
changes to the .xls file Built-in will be reflected on the table in autocad.


(*) or "to be saved by name"

(**) the file may also be saved, but the changes made to the autocad table are reflected on the built-in .xls, not in the one from which you left, which is what happened to you having "simply glued". . .

 

[reggio]

Grazie!

Are you using ole objects?
test with this methodhttp://ctrl-alt-cad.blogspot.it/2010/04/collegamenti-dati-ms-excel.html

with your method I managed to connect everything but I find it less immediate than the system suggested by gp.

xls external file- in the excel file "Saved with name" (*) select the range of cells to paste
- in autocad pastespec -> paste link -> microsoft excel worksheet (code)
changes made to the table in autocad by opening the .xls (double/triple/quadruple click) can be saved in .xls original.
changes to the .xls file original will be reflected on the table in autocad.

with both methods However, remains discovered an option that would be very important, inserting rows or columns:
if in the excel file a row or column is added, the existing ones are "moved" and the last disappears to make room for the one just inserted in the middle...
is there no way to expand (or reduce, in case you delete row or column) the link of excel on autocad? That would be perfect! :

 

[GP.]

insert or delete the rows/columns you want, then repaint, put a second.

 

[reggio]

ciao

insert or delete the rows/columns you want, then repaint, put a second.

... uhmmm no is that from us: today gino makes a change on excel and closes, then Roman adds a line on excel and closes, tomorrow roberto edit on excel and closes, then arrives giorgio opening autocad and press launches on plotter...
if there is good, he realizes, blasphemy and begins to ask everyone what were the initial areas to print:
in a press of "pieces" of connected excels there are tens and tens will be to be reset ...
if it goes badly takes it for good and combines crazy cases (type elephant heads mounted on ant bodies ..)

for this he was interested and I asked

is there no way to expand (or reduce, in case you delete row or column) the link of excel on autocad? That would be perfect! :

 

[GP.]

if you are many to use that file use tables with data connection (tristan docet).

 

[reggio]

... among other things, with your method we tested that unfortunately, when we go to iron the design, even if we include the whole table/s in the selection window, the tables change scale uncontrolledly accavallandosi among them ...

if you are many to use that file use tables with data connection (tristan docet).

... but is it not the method that you suggested to me and that you have the above "defects"?

Did I miss something?

 

[GP.]

originally written by gp.
if you are many to use that file use tables with data connection (tristan docet). ... but is it not the method that you suggested to me and that you have the above "defects"?

no, if you read well my method is to use ole objects.
this is the method of "data connection" indicated by tristan with this link: http://ctrl-alt-cad.blogspot.it/2010...-ms-excel.html

... among other things, with your method we tested that unfortunately, when we go to iron the design, even if we include the whole table/s in the selection window, the tables change scale uncontrolledly accavallandosi among them ...

That's what autocads with the ole.