Spreadsheet wants me to save when I hit enter or attempt to drag formula down a column

[marshallmr]

I had to add additional job functions to my workbook. I then made a change to the formula to include the new job junctions. I am now attempting to excute the formula by hitting enter or to drag the formula in from cell F2 (Tab - Employee Info) down column E it is asking for me to save the document. The formula is below: Thank you in advance.




=IF(C2="","",IF(B2=" Breakdown/Floor Unloader",HLOOKUP(E2,'Production Standards'!$B$2:$I$3,2,FALSE),IF(B2="Pallet Unloader",HLOOKUP(E2,'Production Standards'!$B$8:$I$9,2,FALSE),IF(B2="Pallet Verifier",HLOOKUP(E2,'Production Standards'!$B$11:$I$12,2,FALSE),IF(B2="Breakdown/Floor Verifier",HLOOKUP(E2,[ProductionStandards]ProductionStandards!$B$5:$I$6,2,FALSE),IF(B2="Slotter",HLOOKUP(E2,[ProductionStandards]ProductionStandards!$B$14:$I$15,2,FALSE),IF(B2="Loader",HLOOKUP(E2,'Production Standards'!$B$17:$I$18,2,FALSE),IF(B2="Loose Freight",HLOOKUP(E2,'Production Standards'!$B$20:$I$21,2,FALSE),""))))))))

[Richard Buttrey]

Are you sure you're being asked to Save the workbook

Your formula is linked to an external workbook called Production Standards.

When I drag the formula down it checks to see whether it should update the values from another workbook which may have changed.

[marshallmr]

Production Standards is actually a tab within the workbook. It should be referencing data from that tab.

Yes, when I attempt to drag the formula down it pops up a save window.

[marshallmr]

I resolved myself, found where a space was required in the formula. Thank you to all who looked at the post.