StarGate Posted September 24, 2001 Share Posted September 24, 2001 Hi, We are using VectorWorks 8.5.2 NL. We are experiencing a very nasty problem with worksheets inside a VectorWorks document. We developed a calculation document which calculate the prices of houses. So our designers draw the houses and the price is calculated in several worksheets. We receive a lot of #CELVALUE errors randomly. Regretfully it is no human error or wrong code which is the cause of this error. One time all worksheets are working fine and another time those same worksheets get error #CELLVALUE. We can fix the error by taking a new worksheet and copy the contents of the faulty one into the new one. Without any alterations the #CELVALUE error disappears in the copied version while remaining in the original one. Early this year someone removed or renamed the document in the Macintosh finder while it was open and afterwards saved it. Since then we got those errors. We made a completely new document ("Nieuw") and copied everything into it. But we still get those errors. Does anybody know how we can solve this nasty problem forever. Within a few weeks we will upgrade to 9.1, would this automatically solve our present problems? We would appreciate your help very much because those errors cost us time and money. Can we contact someone from Nemetschek technical department? We thank you very much in advance and wish you a nice day. Friendly greetings, StarGate System-administrator Woods Email : kristiaan.verberne@skynet.be Dessel Belgium Quote Link to comment
Matthew Giampapa Posted September 25, 2001 Share Posted September 25, 2001 This sounds quite likely, if you can narrow down the steps to cause the error after it has been fixed we can try to convert the file here and see how it behaves in version 9. We can also try to fix the root cause of the problem in the version 8 file as well. This sounds like the kind of problem which upgrading will fix, however I don't have sufficient knowledge of changes made in this area of the program to be sure. If you can email the file to tech@nemetshek.net I will have someone who specialized in worksheet issues look into the problem. Matthew Giampapa Technical Support quote: Originally posted by StarGate: Hi, We are using VectorWorks 8.5.2 NL. We are experiencing a very nasty problem with worksheets inside a VectorWorks document. We developed a calculation document which calculate the prices of houses. So our designers draw the houses and the price is calculated in several worksheets. We receive a lot of #CELVALUE errors randomly. Regretfully it is no human error or wrong code which is the cause of this error. One time all worksheets are working fine and another time those same worksheets get error #CELLVALUE. We can fix the error by taking a new worksheet and copy the contents of the faulty one into the new one. Without any alterations the #CELVALUE error disappears in the copied version while remaining in the original one. Early this year someone removed or renamed the document in the Macintosh finder while it was open and afterwards saved it. Since then we got those errors. We made a completely new document ("Nieuw") and copied everything into it. But we still get those errors. Does anybody know how we can solve this nasty problem forever. Within a few weeks we will upgrade to 9.1, would this automatically solve our present problems? We would appreciate your help very much because those errors cost us time and money. Can we contact someone from Nemetschek technical department? We thank you very much in advance and wish you a nice day. Friendly greetings, StarGate System-administrator Woods Email : kristiaan.verberne@skynet.be Dessel Belgium 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.