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.
Do you want to keep the input file name with your output table?
Best Regards
Arundhuti
@Tyro_abc , No Output file name could be anything, it is not mandatory. Thanks