The formula is too long formulas should not be longer than 8192 characters

I don't really know anything about that, but I'm guessing that a UDF would not have the same problem.

Read this Article please:
https://www.experts-exchange.com/questions/28227993/Weird-Excel-Error-on-Save.html

Hi,

Please post your formula

Formula is
=CHOOSE(1+([@[Work Area]]="WAP-1103 - Intelligent Transport System - ITS")*1+([@[Work Area]]="WAP-1102 - Zone 12 - North Bound")*2+([@[Work Area]]="WAP-1101 - General")*3+([@[Work Area]]="WAP-1001 - Traffic Management")*4+([@[Work Area]]="WAP-0601 - Site Establishment")*5+([@[Work Area]]="WAP-0401 - Torrens Road")*6+([@[Work Area]]="WAP-0310 - Torrens Road Bridge")*7+([@[Work Area]]="WAP-0309 - TOP OF WALL BARRIERS")*8+([@[Work Area]]="WAP-0308 - NOISE WALL CONSTRUCTION")*9+([@[Work Area]]="WAP-0307 - Hawker / Hurtle Bridge / Pump Station / Cedar Ave Pedestrian Bridge")*10+([@[Work Area]]="WAP-0305 - OUTER HARBOR RAIL BRIDGE")*11+([@[Work Area]]="WAP-0304 - SERVICES BRIDGE")*12+([@[Work Area]]="WAP-0303 - PORT ROAD BRIDGE")*13+([@[Work Area]]="WAP-0302 - GRANGE ROAD")*14+([@[Work Area]]="WAP-0301 - TAYLORS BRIDGE")*15+([@[Work Area]]="WAP-0203 - Lowered Motorway - North")*16+([@[Work Area]]="WAP-0202 - Surface Level Civil Works - Zone 9/10")*17+([@[Work Area]]="WAP-0201 - Surface Level Civil Works - Zone 7")*18+([@[Work Area]]="WAP-0104 - Lowered Motorway - South")*19+([@[Work Area]]="WAP-0103 - Surface Level Civil Works - Port Rd Medians and Temporary Works - Zone 6")*20+([@[Work Area]]="WAP-0102 - NB & SB  Surface Roads - Zone 3/5")*21+([@[Work Area]]="NB & SB  Surface Roads - Zone 3/5")*22+([@[Work Area]]="Surface Level Civil Works - Zone 9/10")*23+([@[Work Area]]="Surface Level Civil Works - Zone 7")*24+([@[Work Area]]="Surface Level Civil Works - Port Rd Medians and Temporary Works - Zone 6")*25+([@[Work Pack]]="0701-01 - Port Road Gas Transmission Main - Relocation SAPN Early Works")*26+([@[Work Pack]]="0701-01 - SAPN Early Works")*27+([@[Work Pack]]="0701-03 - ElectraNet")*28+([@[Work Pack]]="0701-03 - Port Road DN450 Sewer Gravity - Realignment ElectraNet")*29+([@[Work Pack]]="0701-04 - Forster Street Horizontal Directional Drill")*30+([@[Work Pack]]="0701-04 - Port Road SAPN - Relocation Forster Street Horizontal Directional Drill")*31+([@[Work Pack]]="0701-05 - Port Road Telstra - Relocation")*32+([@[Work Pack]]="0701-06 - Sewer Main Installation - Gravity/Pumping (WWPS 1)")*33+([@[Work Pack]]="0701-07 - Sewer Main Installation - Gravity/Pumping (WWPS 2)")*34+([@[Work Pack]]="0701-08 - Supply & Install WWPS 1")*35+([@[Work Pack]]="0701-09 - Supply & Install WWPS 2")*36+([@[Work Pack]]="0701-10 - Port Road DN450 Sewer Gravity - Realignment")*37+([@[Work Pack]]="0701-11 - Port Road Gas Transmission Main - Temporary")*38+([@[Work Pack]]="0701-12 - Port Road Gas Transmission Main - Permanent")*39+([@[Work Pack]]="0701-13 - Water main Installation - Port Road")*40+([@[Work Pack]]="0701-14 - Water main Installation - Grange / Manton")*41+([@[Work Pack]]="0701-15 - Water main Installation - Hawker / Hurtle")*42+([@[Work Pack]]="0701-16 - XW30 Watermain")*43+([@[Work Pack]]="0701-17 - 450mm Sewer Microtunnelling shafts")*44+([@[Work Pack]]="0701-18 - Common Services Trench - Port Rd to Forster St")*45+([@[Work Pack]]="0701-19 - Water Main Installations")*46+([@[Work Pack]]="0701-20 - Port Rd Directional Drills - CST & 11kV")*47+([@[Work Pack]]="0701-21 - Port Rd Directional Drill Permanent Lighting Road Crossings")*48+([@[Work Pack]]="0701-21 - Port Rd Lighting")*49+([@[Work Pack]]="0701-22 - Port Rd - Signalling")*50+([@[Work Pack]]="0701-23 - Port Rd - CST")*51+([@[Work Pack]]="0701-24 - Southbound CST - River Torrens to Overland Road")*52+([@[Work Pack]]="0701-25 - Water main Installation - Port Road to Forster Street")*53+([@[Work Pack]]="0701-25 - Water main Installation - Port Road to Forster Street (Linked to 0701-38)")*54+([@[Work Pack]]="0701-26 - Southbound CST - Taylor's Bridge to Manton St")*55+([@[Work Pack]]="0701-27 - Telecoms Dry Services Civil Works")*56+([@[Work Pack]]="0701-28 - Telstra Manhole Lid Modifications")*57+([@[Work Pack]]="0701-30 - Consumer Mains Undergrounding")*58+([@[Work Pack]]="0701-31 - Coglin St Gas Realignment")*59+([@[Work Pack]]="0701-32 - Southbound CST - Torrens Rd to Overland Rd")*60+([@[Work Pack]]="0701-33 - Northern Sewer Mains")*61+([@[Work Pack]]="0701-34 - Southbound CST - Manton St to Port Rd")*62+([@[Work Pack]]="0701-35 - Bridge Water Mains")*63+([@[Work Pack]]="0701-36 - Package 1 -Telstra and SAPN directional drilling and conduits")*64+([@[Work Pack]]="0701-37 - SA Water XW03 to XW08")*65+([@[Work Pack]]="0701-38 - SA Water XW26 & 26A")*66+([@[Work Pack]]="0701-38 - SA Water XW26 & 26A (Linked to 0701-25)")*67+([@[Work Pack]]="0701-39 - SA Water XW20 & 49B & 46")*68+([@[Work Pack]]="0701-47 - Package 2 - Telstra and SAPN Civil Works")*69+([@[Work Pack]]="0701-48 - Package 3 - Telstra and SAPN directional drilling")*70+([@[Work Pack]]="0701-49 - Package 4 - Telstra and SAPN directional drilling")*71+([@[Work Pack]]="0701-50 - Package 5 - Telstra and SAPN Civil Works")*72+([@[Work Pack]]="0701-52 - Package 7 - Telstra and SAPN Civil Works")*73+([@[Work Pack]]="0701-53 - Remaining Traffic Signals Zone 1-6")*74+ ([@[Work Pack]]="Transmission Main - Commissioning")*75+([@[Work Pack]]="0701-54 - APA - Permanent Gas Transmission Main - Stage 2")*76+([@[Work Pack]]="0701-55 - APA - Gas Distribution Network - South of Port Road")*77+([@[Work Pack]]="0701-56 - Temporary Support for Bridge Services")*78+([@[Work Pack]]="0701-57 - Hawker St Temporary Gas")*79+([@[Work Pack]]="0701-58 - Southbound CST (Forster to Paget) CH 1500 - 1840")*80+([@[Work Pack]]="0701-59 - Southbound CST (Forster to Paget) CH 1500 - 1840")*81+([@[Work Pack]]="0701-60 - APA - Gas Distribution Network - North of Port Road")*82+([@[Work Area]]="WAP-0104 - Lowered Motorway")*83+([@[Work Area]]="WAP-0204 - Surface Level Civil Works - Zone 9/10/10a - South Bound")*84+([@[Work Area]]="Surface Level Civil Works - Zone 7")*85+([@[Work Area]]="Services incl. Relocations")*86+([@[Work Area]]="Surface Level Civil Works - Zone 9/10")*87+([@[Work Area]]="Surface Level Civil Works - Port Rd Medians and Temporary Works - Zone 6")*88+([@[Work Area]]="NB & SB  Surface Roads - Zone 3/5")*89+([@[Work Pack]]="11kV  Substation to Roberts Street")*90+([@[Work Pack]]="450mm Sewer Microtunnelling shafts")*91+([@[Work Pack]]="66kV Eastern Circuit Civil Works (Zone 7 - Zone 10)")*92+([@[Work Pack]]="East Side - Stormwater")*93+([@[Work Pack]]="Northbound Surface Road CST")*94+([@[Work Pack]]="Northbound Surface Road Earthworks")*95+([@[Work Pack]]="Northbound Surface Road Stormwater")*96+([@[Work Pack]]="Piling rig/ crane pad construction (Grange Rd intersection)")*97+([@[Work Pack]]="Port Road DN450 Sewer Gravity - Realignment")*98+([@[Work Pack]]="Port Road Gas Transmission Main - Permanent")*99+([@[Work Pack]]="Port Road Gas Transmission Main - Temporary")*100+([@[Work Pack]]="SAPN Early Works")*101+([@[Work Pack]]="Sewer Main Installation - Gravity/Pumping (WWPS 1)")*102+([@[Work Pack]]="Sewer Main Installation - Gravity/Pumping (WWPS 2)")*103+([@[Work Pack]]="Southbound Surface Road Earthworks")*104+([@[Work Pack]]="Supply & Install WWPS 1")*105+([@[Work Pack]]="Test Pile Pit Decommissioning")*106+([@[Work Pack]]="Water main Installation - Hawker / Hurtle")*107+([@[Work Pack]]="Water main Installation - Port Road")*108+([@[Work Pack]]="West Side - Stormwater")*109+([@[Work Pack]]="Zone 3 : Clay Pit Rehabilitation")*110+([@[Work Pack]]="0701-54 - APA - Permanent Gas")*111,"Error","Dirk Fuhrmann","Paolo Moretti","Rohan Perera","Brian McInerny","Greg Dickson","Ashkan Saljoughi","Dobu Ungureanu","Dobu Ungureanu","Dobu Ungureanu","Costa Casiou","Chris May","Dobu Ungureanu","Dobu Ungureanu","Nick Drinkwater","Nick Drinkwater","Carmelo Piccione","Costa Casiou","Chris May","Carmelo Piccione","Dobu Ungureanu","Nick Drinkwater","Nick Drinkwater","Costa Casiou","Chris May","Dobu Ungureanu","Dirk Fuhrmann","Dirk Fuhrmann","Mark Curtin","Mark Curtin","Mark Curtin","Mark Curtin","Mark Curtin","Dirk Fuhrmann","Dirk Fuhrmann","Dirk Fuhrmann","Dirk Fuhrmann","Dirk Fuhrmann","Dirk Fuhrmann","Mark Curtin","Dirk Fuhrmann","Dirk Fuhrmann","Costa Casiou","Mark Curtin","Mark Curtin","Chris May","Mark Curtin","Dirk Fuhrmann","Dobu Ungureanu","Dobu Ungureanu","Dirk Fuhrmann","Dobu Ungureanu","Derek Fabel","Costa Casiou","Mark Curtin","Derek Fabel","Mark Curtin","Mark Curtin","Mark Curtin","Mark Curtin","Derek Fabel","Paolo Moretti","Derek Fabel","Dirk Fuhrmann","Mark Curtin","Mark Curtin","Mark Curtin","Mark Curtin","Mark Curtin","Mark Curtin","Mark Curtin","Mark Curtin","Nick Drinkwater","Mark Curtin","Nick Drinkwater","Mark Curtin","Mark Curtin","Mark Curtin","Mark Curtin","Mark Curtin","Dirk Fuhrmann","Derek Fabel","Mark Curtin","Carmelo Piccione","Costa Casiou","Chris May","Mark Curtin","Costa Casiou","Dobu Ungureanu","Nick Drinkwater","Chris May","Mark Curtin","Costa Casiou","Dobu Ungureanu","Chris May","Costa Casiou","Costa Casiou","Nick Drinkwater","Dirk Fuhrmann","Dirk Fuhrmann","Dirk Fuhrmann","Dirk Fuhrmann","Dirk Fuhrmann","Dirk Fuhrmann","Nick Drinkwater","Dirk Fuhrmann","Costa Casiou","Costa Casiou","Dirk Fuhrmann","Dobu Ungureanu","Nick Drinkwater","Mark Curtin")

You scared everyone. LOL

Thank you all for your input.