Peter Telleman Posted November 14, 2024 Share Posted November 14, 2024 (edited) @Pat Stanford @Luka Stefanovic Hi everyone, I got a question from one of my material booking colleagues, is it possible to automatically export worksheets to excel files? So for instance, when I update the worksheets in a drawing, it automatically updates an excel sheet connected to that. I've read about referencing a file when importing an excel file as a worksheet, for no apparent reason I'm assuming this might work the other way as well?? Because to me it looks like when working with an imported worksheet, the excel file is leading, and I can't recalculate my Vectorworks drawing correctly when counts in my drawing change. thanks for any tips or answers on this, Peter Edited November 14, 2024 by Peter Telleman Quote Link to comment
Peter Telleman Posted November 14, 2024 Author Share Posted November 14, 2024 @Jesse Cogswell Hi Jesse, read a thread which mentioned your tool, does that tool do what I'm looking for? Again, what I'm looking for is something that updates the counts in worksheets in Vectorworks to an excel file. So basically, when I recalculate my worksheets in Vectorworks, it refreshes the count in my excel sheet (or it does with a mouseclick somewhere). I don't mind if the initial setting up of this takes a little time, since we very often work on these projects for months. thanks, Peter Quote Link to comment
Vectorworks, Inc Employee Luka Stefanovic Posted November 28, 2024 Vectorworks, Inc Employee Share Posted November 28, 2024 Hi @Peter Telleman you can export Vectorworks worksheets to Excel, you can even reference Excel files in Vectorworks models and then push the data from Vectorworks to Excel and vice versa in a two-way data exchange, but you can't do it automatically. References need to be updated and worksheets recalculated, data pushed from Vectorworks to Excel or worksheets exported manually. There's no automatic recalculation because if it was doing it that would mean that every time there is a small change in the model, worksheets would be recalculating and if you had a big database model, your machine would be constantly blocked. 2 Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.