Pivot Tables Field List Error

%3CLINGO-SUB%20id%3D%22lingo-sub-2953155%22%20slang%3D%22en-US%22%3EPivot%20Tables%20Field%20List%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2953155%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20fairly%20new%20to%20excel%2C%20but%20I%20have%20been%20working%20on%20a%20project%20that%20requires%20a%20lot%20of%20pivot%20tables.%20I%20just%20found%20out%20a%20more%20efficient%20way%20to%20calculate%20some%20of%20my%20data%20which%20eliminated%20the%20need%20for%20some%20of%20the%20pivot%20tables%20that%20I%20made.%20Since%20I%20deleted%20those%20tables%2C%20excel%20has%20not%20allowed%20me%20to%20move%20certain%20fields%20into%20the%20buckets%20(is%20that%20what%20they're%20called%3F)%20or%20the%204%20quadrants%20in%20the%20field%20list%20section.%20Is%20there%20a%20way%20to%20fix%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2953155%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2956309%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Tables%20Field%20List%20Error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2956309%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1214855%22%20target%3D%22_blank%22%3E%40connorhart34%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20post%20has%20been%20up%20a%20day%2C%20been%20viewed%20by%20over%2040%20people%2C%20but%20with%20no%20reply%20(until%20now)....%20I'm%20suspecting%20it's%20because%20you%20just%20don't%20give%20enough%20info%20for%20anybody%20to%20do%20anything%20other%20than%20take%20a%20wild%20guess%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20for%20you%20to%20post%20a%20copy%20of%20the%20spreadsheet%3F%20If%20it%20contains%20confidential%20info%20of%20any%20kind%2C%20be%20sure%20to%20anonymize%20it--change%20name%2C%20delete%20identifiers.%20Short%20of%20that%2C%20a%20mockup%20that%20replicates%20what%20you're%20trying%20to%20do.%20Not%20images%2C%20please%3A%20%3CU%3Eactual%20spreadsheets%2C%20accompanied%20if%20at%20all%20possible%20by%20a%20better%20description%20of%20the%20big%20picture--what%20is%20the%20business%20(or%20personal)%20objective%20or%20purpose%20of%20the%20workbook%3F%3C%2FU%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am fairly new to excel, but I have been working on a project that requires a lot of pivot tables. I just found out a more efficient way to calculate some of my data which eliminated the need for some of the pivot tables that I made. Since I deleted those tables, excel has not allowed me to move certain fields into the buckets (is that what they're called?) or the 4 quadrants in the field list section. Is there a way to fix this?

1 Reply

@connorhart34 

 

Your post has been up a day, been viewed by over 40 people, but with no reply (until now).... I'm suspecting it's because you just don't give enough info for anybody to do anything other than take a wild guess

 

Is it possible for you to post a copy of the spreadsheet? If it contains confidential info of any kind, be sure to anonymize it--change name, delete identifiers. Short of that, a mockup that replicates what you're trying to do. Not images, please: actual spreadsheets, accompanied if at all possible by a better description of the big picture--what is the business (or personal) objective or purpose of the workbook?