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)