SOLVED
Home

Query Problem

%3CLINGO-SUB%20id%3D%22lingo-sub-327182%22%20slang%3D%22en-US%22%3EQuery%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327182%22%20slang%3D%22en-US%22%3E%3CPRE%3E%26nbsp%3B%3C%2FPRE%3E%3CP%3E%3CSPAN%3EHello%2C%20I%20have%20a%20problem%2C%20I%20have%20a%20Query%20that%20pulls%20data%20to%20a%20dynamic%20table%20in%20Excel%2C%20however%2C%20there%20are%203%20fields%20that%20do%20not%20exist%20in%20the%20database%20that%20need%20to%20be%20filled%20manually%2C%20but%20when%20updating%20the%20fields%2C%20they%20are%20sometimes%20disordered%20by%20are%20static%2C%20I%20wanted%20to%20know%20some%20way%20to%20nest%20these%20static%20fields%20with%20the%20ID%20of%20the%20PivotTable.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-327182%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327449%22%20slang%3D%22en-US%22%3ERe%3A%20Query%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327449%22%20slang%3D%22en-US%22%3EYou%20can%20keep%20it%20in%20the%20same%20workbook%2C%20but%20it%20cannot%20be%20in%20the%20same%20table.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327316%22%20slang%3D%22en-US%22%3ERe%3A%20Query%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327316%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%2C%20but%20I%20had%20already%20thought%20about%20it%2C%20I%20really%20wanted%20to%20keep%20in%20the%20same%20workbook%2C%20according%20to%20the%20refresh%20of%20the%20query.%20Thank%20you%20anyway!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327291%22%20slang%3D%22en-US%22%3ERe%3A%20Query%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327291%22%20slang%3D%22en-US%22%3EYou%20will%20have%20to%20add%20your%20own%20-static-%20table%20to%20the%20file%20which%20contains%20the%20manually%20entered%20information.%20Make%20sure%20that%20table%20has%20a%20column%20with%20which%20you%20can%20link%20the%20information%20to%20the%20table%20which%20pulls%20data%20from%20the%20database.%20Now%20you%20can%20add%20the%20manual%20table%20to%20your%20pivot%20table%20and%20Excel%20will%20ask%20you%20for%20the%20relationship%20between%20the%20two%20tables.%3C%2FLINGO-BODY%3E
Andr_Mattos
New Contributor
 

Hello, I have a problem, I have a Query that pulls data to a dynamic table in Excel, however, there are 3 fields that do not exist in the database that need to be filled manually, but when updating the fields, they are sometimes disordered by are static, I wanted to know some way to nest these static fields with the ID of the PivotTable.

3 Replies
Solution
You will have to add your own -static- table to the file which contains the manually entered information. Make sure that table has a column with which you can link the information to the table which pulls data from the database. Now you can add the manual table to your pivot table and Excel will ask you for the relationship between the two tables.

Thanks, but I had already thought about it, I really wanted to keep in the same workbook, according to the refresh of the query. Thank you anyway!

You can keep it in the same workbook, but it cannot be in the same table.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies