Power Query dont update

[Tonyhansson]

Hi


I have an Excel sheet with 2 power Querys, both are set up to refresh on start up.

When I open, only 1 Query refresh. (Manual both refresh with no problem)


How can I force Excel to refresh all, on start up?


Regards


Tony

[alansidman]

Please Login or Register  to view this content.

or

Clcik on Queries and Connections

Select Properties and then check the box highlighted in the picture

[AliGW]

Set the query properties to refresh on file open.

[Tonyhansson]

Set the query properties to refresh on file open.

This is already done

[Tonyhansson]

Please Login or Register  to view this content.

or

Clcik on Queries and Connections

Select Properties and then check the box highlighted in the picture

I will try to use vba

[Tonyhansson]

Hi

This is still not working.

1st. Time I open workbook only 1 query is refreshed, if I open and close, 2nd time both query are refeshed.


I have also made a import from access using a vba code forcing to open and refresh the workbook, but
Still only one query is updated


Did anyone try anything like this?


Regards

Tony

[AliGW]

I don't have any problems if I have set queries to refresh on opening. Without seeing your workbook, it's really hard to guess what the problem might be. However, if the query that is not updating is dependent on another that hasn't been refreshed, then this might be your problem, but it is only a stab in the dark.