Microvellum Knowledge Network

Activity Token not Valid - Workbook 'S'

Library 50_3 and 48_0

 

I am having an issue where when using the 50_3 library I am continually getting an Activity Token not Valid - Workbook 'S' error when creating a new workorder with any cabinets.  When using our older 48_0 library I don’t get this issue. 

 

I think I have narrowed it down to the Activity Tokens built into the carcass subassembly.  In our 48_0 library there is no #Name? issue in the formulas but in the 50_3 there is obviously a problem.  I have compared the formulas between the 2 libraries and everything is the same.  I doubled checked and when in the global ‘F!’ workbook the Sand_Stain_Finish_Products_After_Assembly appears to be a defined name and shows correctly.  But in the subassembly if I simply put = W!Sand_Stain_Finish_Products_After_Assembly I get a name error.

 

#Name? Formulas

601 - =IF(W!Sand_Stain_Finish_Products_After_Assembly=1,IF(W!No_Sanding_or_Finishing_on_Veneer_Parts=1,0,((Height*Depth)*(2+Left_Fin_End+Right_Fin_End)+(Width*Height))/IF(Units=1,144,1000000)),0)

602 - =IF(W!Sand_Stain_Finish_Products_After_Assembly=1,IF(W!Sanding_Clear_Finishing_on_Veneer_Parts=1,((Height*Depth)*(2+Left_Fin_End+Right_Fin_End)+(Width*Height))/IF(Units=1,144,1000000),0),0)

603 - =IF(W!Sand_Stain_Finish_Products_After_Assembly=1,IF(W!Sanding_Staining_Clear_Finishing_on_Veneer_Parts=1,((Height*Depth)*(2+Left_Fin_End+Right_Fin_End)+(Width*Height))/IF(Units=1,144,1000000),0),0)






 

 



    MVU eLearning



    Grow Your Knowledge
    Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.


      Follow us on:

               

        Google Review