Output file with preformatted Pivot

Question

Hi Team - I am facing issue while creating output file to retain its formatting & pivot table.

I have provided here 2 Input files, and One Output file.

In Output file, I want to retain the Pivot table as is, there should not be any error while opening the file.

Input files :

1. Check 1_with data_Input 1.xlsx

2. To include data_Input 2.xlsx

Expected Output ( with retained Pivot table)

1. Check 1_with data_Output.xlsx

Please advise how to make sure Output file contains data from both Input files and also Pivot table is retained.

Check 1_with data_Input 1.xlsx

To include data_Input 2.xlsx

Check 1_with data_Output.xlsx

SAURABHGHOTKAR · Answer

@Tyro_abc , No Output file name could be anything, it is not mandatory. Thanks

Tyro_abc · Answer

Hi @SAURABHGHOTKAR

Do you want to keep the input file name with your output table?

Best Regards

Arundhuti