KarelKat
New Member
- Joined
- Jun 4, 2021
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Hi
I am working on a spreadsheet that queries and imports data from an Excel file shared to DropBox.
How do I change the query to be able to use the spreadsheet on any PC that has the DropBox link instead of only the "admin" PC?
Current query code:
let
Source = Excel.Workbook(File.Contents("C:\Users\admin\Dropbox\Reporting\Time\Export\Filename1.xls"), null, true),
#"ImportedFile1" = Source{[Name="ImportedFile1"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"ImportedFile1"),
in
I am working on a spreadsheet that queries and imports data from an Excel file shared to DropBox.
How do I change the query to be able to use the spreadsheet on any PC that has the DropBox link instead of only the "admin" PC?
Current query code:
let
Source = Excel.Workbook(File.Contents("C:\Users\admin\Dropbox\Reporting\Time\Export\Filename1.xls"), null, true),
#"ImportedFile1" = Source{[Name="ImportedFile1"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"ImportedFile1"),
in