Forum Discussion
Mirror server updated sheet to another sheet
Hello,
I'm in a bit of a weird place with my knowledge base, learning as I go for what I need to do, so I am not sure if I am asking even the right question.
My situation is thus;
I have a raw data sheet in my workbook which is updated via a server every time the book is opened.
I am currently trying to "mirror" that sheet into another separate sheet so that I can format as a table.
If I try to format the server updated sheet, it is reverted back to it's initial raw data.
What would be the best way to "mirror" that raw data sheet so that I can format the "mirrored" sheet as a table to work with it? Ideally the "mirrored" sheet would update along side the raw data sheet.
Thanks in advance,
Shaun
sconway1985 Your comments in italics, my comment in regular font below them:
In this workbook there is the raw data sheet which is updated automatically with data fed from SharePoint.
How is this done? Via PowerQuery?
I cannot make changes to that raw data sheet, such as formatting it as a table, because whenever new data is input into SharePoint, the sheet is reverted back to its original form as just raw data.
That's where I believe PowerQuery may come in. Set it up to connect to the data, do whatever cleaning and formatting you need and load it to the Data Model where you can do the DAX measures and from there you create the pivot tables.
But perhaps I'm totally missing the point. Difficult to visualize your project based on text only. At least for me.
11 Replies
- Hi
You can copy the sheet, usually copied with the formula and references.
It depends on the way on how the first sheet get the data from the server.- Hi Jihad,
Copying the sheet wouldn't be enough. This is an automated report that is updated each morning.
I need the mirror sheet to update as the raw data sheet is updated on it's own.sconway1985 Perhaps you can connect to the raw date using Power Query and do whatever transformations are needed and load the result back into an Excel table. Every morning, refresh the query or set-up the query such that it automatically refreshes when the workbook opens and the "mirror" table will change with it.
