Excel PQ Abfrage - Formatierungen sind nach Aktualisierung weg

%3CLINGO-SUB%20id%3D%22lingo-sub-1362397%22%20slang%3D%22de-DE%22%3EExcel%20PQ%20Query%20-%20Formatting%20is%20gone%20after%20update%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1362397%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%20worthy%20support%20team%2C%3C%2FP%3E%3CP%3EI%20created%20a%20table%20from%20a%20PQ%20query.%20Here%20I%20would%20like%20to%20format%20a%20few%20cells%20myself%20(e.g.%20cell%20color).%20As%20soon%20as%20I%20update%20the%20query%2C%20my%20formatting%20will%20be%20overwritten%2C%20even%20though%20I%20removed%20the%20%22Keep%20Formatting%22%20checkmark.%20Can%20someone%20help%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMfG%2C%20CB00874%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1365533%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20PQ%20Abfrage%20-%20Formatierungen%20sind%20nach%20Aktualisierung%20weg%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1365533%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F657349%22%20target%3D%22_blank%22%3E%40CB00874%3C%2FA%3E%26nbsp%3BCan%20you%20provide%20the%20OS%20you're%20on%20and%20the%20current%20Excel%20build%20number%20that%20you%20have%20installed%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hallo wertes Support Team,

ich habe eine Tabelle aus einer PQ Abfrage erstellt. Hier möchte ich nun ein paar Zellen selbst formatieren (zbsp. Zellfarbe). Sobald ich die Abfrage aktualisiere, wird meine Formatierung überschrieben, obwohl ich den Haken bei "Formatierung beibehalten" entfernt habe. Kann mir jemand helfen?

 

MfG, CB00874

1 Reply

@CB00874 Can you provide the OS you're on and the current Excel build number that you have installed?

 

Thanks.