Forum Discussion
Power query automatically refresh
I have one Excel file that Excel file contain one sheet which is called "Sales". In Sales sheet contain 3 column. In Sales sheet column 2 and 3 has data and column 1 always is empty.
Saxon10
Please check the attached Excel File. When you update data in sale sheet, the table in sale1 will be refreshed. I also provided a button to refresh if you need to use it.
https://1drv.ms/x/s!AmoScH5srsIYgZItGfJ7MdKoZVtEEw?e=UxbiRO
7 Replies
You are connecting to a single Excel file where the sheets Sale and Sale1 exist. If you have a single query that references the two sheets, you get the updated data from both sheets. If the different queries are made for each sheet, you need to refresh separately. It also depends on how you have set up the connection.
Thnaks for your reply and advise. Yes, I am connecting single in same file with two different sheet. The difference in-between two sheet (sales and sales1) is blanks column (Item).
In order to get the automatic refresh in sales1 sheet based on the sales sheet without opening Excel file or time setting. What kind of connection or setting need to be setup in order to get the automatic refresh.
Example: If I add data in sales sheet then it's automatically need to be replicate in Sales1 sheet.
Could you please provide artical or snapshot more understanding the logic.
Sales1
Sales
I am using old Excel version so unable to attached file.
Sales1
COUNTRYDATE
UAE 05/05/2021 00:00
AUS 02/04/2021 00:00
INDIA 02/04/2021 00:00
TML 05/05/2021 00:00
SRI 02/04/2021 00:00
PAK 02/04/2021 00:00
INDIA 23/03/2021 00:00
CAND 02/04/2021 00:00
US 02/04/2021 00:00
NEWL 02/04/2021 00:00
UK 02/04/2021 00:00
SalesITEMCOUNTRYDATE
INDIA 02/04/2021PAK 02/04/2021
US 02/04/2021
UK 02/04/2021
AUS 02/04/2021
SRI 02/04/2021
CAND 02/04/2021
NEWL 02/04/2021
INDIA 23/03/2021
UAE 05/05/2021
TML 05/05/2021
