Edit source data in combined Excel file

%3CLINGO-SUB%20id%3D%22lingo-sub-2710373%22%20slang%3D%22en-US%22%3EEdit%20source%20data%20in%20combined%20Excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2710373%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20fellow%20Excellers!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20edit%20the%20source%20data%20from%20a%20combined%20file%3F%3C%2FP%3E%3CP%3EMy%20situation%3A%3C%2FP%3E%3CP%3EI%20have%20a%20folder%20with%20several%20excel%20workbooks%20with%20tables%20in%20the%20same%20format%2C%20and%20with%20the%20same%20tab%20name.%26nbsp%3B%3CSPAN%3EEvery%20day%2C%20a%20new%20file%20is%20added.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EWith%20Power%20Query%20I%20can%20easily%20combine%20all%20workbooks%2C%20by%20just%20importing%20and%20combining%20the%20folder%20where%20all%20workbooks%20are%20stored.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20would%20like%20to%20do%20is%20to%20be%20able%20to%20edit%20the%20data%20in%20the%20combined%20%22master%22-file%2C%20and%20get%20it%20edited%20in%20the%20source%20file%20as%20well.%20Is%20that%20at%20all%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20afraid%20of%20using%20more%20advanced%20features%2C%20including%20VBA.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20to%20hear%20from%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3EJosefin%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2710373%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2715427%22%20slang%3D%22en-US%22%3ERe%3A%20Edit%20source%20data%20in%20combined%20Excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2715427%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1144288%22%20target%3D%22_blank%22%3E%40Josefin_Gerholm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eonly%20the%20source%20file%20can%20be%20edited%20to%20update%20the%20power%20queried%20(query%20by%20folder)%20master%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi fellow Excellers!

 

Is there any way to edit the source data from a combined file?

My situation:

I have a folder with several excel workbooks with tables in the same format, and with the same tab name. Every day, a new file is added.

 

With Power Query I can easily combine all workbooks, by just importing and combining the folder where all workbooks are stored.

 

What I would like to do is to be able to edit the data in the combined "master"-file, and get it edited in the source file as well. Is that at all possible?

 

I'm not afraid of using more advanced features, including VBA.

 

Hope to hear from you!

 

Best regards,

Josefin    

3 Replies

@Josefin_Gerholm 

 

only the source file can be edited to update the power queried (query by folder) master file.

Perhaps you should be considering a database solution rather than Excel. The report to users could still be via Excel but the master data would be in the form of database tables.
Yes, that's probably the best solution. I will look in to that, thanks for the reply!