Jump to content
Sign in to follow this  
Jeff Mac-User

Data between 2 worksheets

Recommended Posts

I have created and attached some records, I know how to create a report. Now I would like to extract data into a separate worksheet for calculating purposes. I tried the syntax mentioned on Pg 15-15 of VW manual with no success. Error message of "Invalid Factor" appears. I can't figure out the proper path name needed between the two worksheets. Any help appreciated. At some time I will be wanting to import/export between a VW database & an Excel spreadsheet. Any info on that procedure will also be appreciated. Thanks.

Share this post

Link to post

We apologize for the lack of clarity in the manual. As with any calculation you must first enter a "=" sign before the formula listed.

I.e. =(Worksheetname:cell/range address)

This should work for you. If you are still having problems please contact Technical Support at (410)-290-5114 for further assistance.


Brian O

Diehl Graphsoft, Inc.

Technical Support

Share this post

Link to post

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.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  


7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114


© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

  • Create New...