topic Re: Newbe Question About Excel in Modeling

Newbe Question About Excel

Anonymous — Tue, 22 May 2007 20:37:47 GMT

Can an Excel spreadsheet be linked into ArchiCAD?

Re: Newbe Question About Excel

TomWaltz — Tue, 22 May 2007 20:47:01 GMT

Nope.

Graphisoft decided to make PDF the interchange format. You would have to make a PDF from Excel then place that into Archicad.

Re: Newbe Question About Excel

Anonymous — Tue, 22 May 2007 20:47:20 GMT

My idea was to insert the excel in Autocad as a linked ole then insert that .dwg file into ArchiCAD as an xref so when the excel is changed it would update in the ArchiCAD sheet.

Re: Newbe Question About Excel

TomWaltz — Tue, 22 May 2007 20:53:12 GMT

Feel free to try it, but my bet is that it won't work. Archicad won't follow the link from Autocad through OLE to Excel.

Re: Newbe Question About Excel

Anonymous — Wed, 23 May 2007 05:05:06 GMT

Jeff,
Like Tom mentioned, Archcad really wants a PDF file. Fortunately though, you can update the PDF link. I usually save my excel file as a PDF in the same folder with the same name (different extension obviously). I place the PDF in Archicad. If I update the excel file, I save over the PDF, and then in Archicad, I update the PDF. One extra step, but it works out all right.

Re: Newbe Question About Excel

Rafal SLEK — Wed, 23 May 2007 06:40:26 GMT

Archicad won't follow the link from Autocad through OLE to Excel.

Funny is, that OLE for xls files was working with version 9 (in PlotMaker)...

Re: Newbe Question About Excel

Haneef Tayob — Fri, 25 May 2007 16:16:17 GMT

OLE used to 'work' in AC9, but GS decided against supporting it in AC10. I loved it when it worked, but my experience with it was that it was very unstable and moody.

The topic has been covered previously under Documentation and in the wishlists.