Hi this might be terribly cryptic - will list actions
From external data base - got raw data as CSV (name = Origin File)
Opened Origin file in Excel - saved as Final File
In Final File - from Data - Get Data CSV - selected Final File (referenced itself - can you do this?)
After transforming in powerquery - added to table
From table - inseted pivot table
So after using the same pivot table for multiple analysis - saved and closed
Sent the analysis to my CEO and only one table saved
Any ideas why?
Many thanks Mark
Suggest you upload your file with your Mcode for analysis with an explanation as what specifically you are attempting.
Not sure without seeing the file and/or query. Did you perhaps save that file as CSV as well? You should have seen a warning that you can't save multiple sheets to a CSV, another one about possible data loss, the table looses all its formatting and you have one sheet left.
Thank you. Didn't get warning and will make sue to save as an excel file in future.
