Hi
I'm trying to create a budget helper for charity staff to make sure costs are calculated correctly when they put together budgets for funders. Some of the source data is confidential - ie Staff Salaries and needs updating regularly by different teams, so I've created source data in different excel worksheets and I've used Get and Transform to bring the data into the sheet that staff will use, I have then set the resulting sheets as 'very hidden'. I have also locked cells to stop people inputting into the wrong place, and protected the workbook. However I've found that staff will still be able to see all the confidential data simply by clicking on the Data Tab/Get and Transform/Show Queries. This brings up a side window which then show the data contained within the query through the 'peek' facility. This effectively means that everyone will be able see the complete salary list, which is clearly not desirable.
I've tried looking at the privacy settings for Get and Transform, but whenever I go to Data Source Settings to set privacy (https://support.office.com/en-gb/ar...31-f7eb-4729-88dd-6a4921380ca9#__toc354511927) in the hope that this will resolve the issue, it says 'you don't have any data source entries saved on this computer'.
I'm very new to this and any help that could be provided would be very gratefully received.
Many thanks
Nick
I'm trying to create a budget helper for charity staff to make sure costs are calculated correctly when they put together budgets for funders. Some of the source data is confidential - ie Staff Salaries and needs updating regularly by different teams, so I've created source data in different excel worksheets and I've used Get and Transform to bring the data into the sheet that staff will use, I have then set the resulting sheets as 'very hidden'. I have also locked cells to stop people inputting into the wrong place, and protected the workbook. However I've found that staff will still be able to see all the confidential data simply by clicking on the Data Tab/Get and Transform/Show Queries. This brings up a side window which then show the data contained within the query through the 'peek' facility. This effectively means that everyone will be able see the complete salary list, which is clearly not desirable.
I've tried looking at the privacy settings for Get and Transform, but whenever I go to Data Source Settings to set privacy (https://support.office.com/en-gb/ar...31-f7eb-4729-88dd-6a4921380ca9#__toc354511927) in the hope that this will resolve the issue, it says 'you don't have any data source entries saved on this computer'.
I'm very new to this and any help that could be provided would be very gratefully received.
Many thanks
Nick