•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Pivot table from 2 sheets
Our take
If you're encountering an error while attempting to append two sheets with the same header in your .xlsm file, it’s essential to resolve any previous issues in your Power Query steps. The message indicates that there are unresolved errors that must be addressed before proceeding. Check for inconsistencies or issues in your data transformation steps prior to the append operation. This often involves verifying that the data types match and ensuring there are no hidden errors in either table.
I have a file and I removed duplicates with Power Query so now I have 2 sheets w the same header.
Both sheets are in table form. I go to Data-Get Data- Combine Queries- Append. When I do that it says “ We cannot modify this step b/c there are errors in prev steps. Please resolve them first.”
This file is saved as .xlsm.
Does anyone know why this is happening.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How can I have multipe pivot tables in one sheet?How can I have multiple pivot tables on a single sheet? I keep getting an error message, and I don't know what to do. edit: https://preview.redd.it/koyyei55d2yg1.png?width=814&format=png&auto=webp&s=4a4a39db42db62a473739d0ffcf0d7eeac33b5e7 submitted by /u/heyitsmereddit [link] [comments]
- Pivot Table Show Details not working, any idea?Hi there, I am facing with a quite unique issue I think. There are some pivots in an Excel file that we use for internal reports for the AP team. The issue is that for the pivots there are several filters applied on, like Intercompany filter or "is the amount negative" etc. but there is the most important one is the Vendor filter, there are numerous vendors excluded, and I was like okay let me just recreate the pivot from the ground, but that would take a bit too much due to the vendor filter. The main problem is that the show details is not working, if I execute a double click on the pivot's total cells then it is loading for a 0.1 second and then nothing happens. If I try it after I close and reopen the file, then it loads for 2 seconds, with the botom right text saying "Reading Data" but then nothing, same results. It is a connection based pivot table, I tried to copy and paste into a new sheet the Pivot, didn't work, I tried to Save & Repair the file, it didn't work. Any idea? submitted by /u/Strange_Cell1142 [link] [comments]
- Power Query Merge Issue - Duplicate Tables After Refresh?Hi everyone, I have two Excel sheets, each containing a table. I’m using Power Query to merge them into a new table (Merge query), and everything works fine initially. However, after I load the result back into Excel, I notice something odd: The merged sheet (called "Merge") is created correctly. But the original two sheets seem to get duplicated again as separate tables (like "Table1" and "Table2"). My main concern is this: I regularly update the data in the original two sheets. So my questions are: Will the merged query automatically reflect updates from the original sheets when I refresh and where to but the new data in the orginal sheets or the new table 1 and table 2? Or do I need to set up something specific to make sure the merge stays updated? Also, is it normal for Power Query to create duplicate tables when loading, or am I doing something wrong? Any clarification would really help. Thanks! submitted by /u/Resident_Quantity827 [link] [comments]