Microvellum Community

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)






 

 



    Toolbox BSB Survey



    Have you been using Toolbox BSB? We'd love to hear what you think!

    Take the Survey

      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:

                 

          ERP for Millwork Shops


          Discover how Microvellum and INNERGY streamline operations for cabinet shops and millwork manufacturers.