Morning everyone.
I've got a spreadsheet that has a data validation list where I don't want it to show blanks or duplicates, so use Power Query to set up a table that condenses the information and the data validation picks information from that table.
The issue I've got is everyone in my office, including myself uses Excel 2013 and form what I understand, Power Query isn't part of 2013 - I had to install it myself.
When the spreadsheet opens, code runs to refresh the table:
When someone else opens the workbook, it gives them the following error:
Which I assume is because Power Query isn't installed on their machine.
Does anyone know if there's a way round this, without me having to get Power Query installed on everyone's machine, which my IT team certainly won't do, lol.
Much appreciated.
Thank you.
Regards
Marhier
I've got a spreadsheet that has a data validation list where I don't want it to show blanks or duplicates, so use Power Query to set up a table that condenses the information and the data validation picks information from that table.
The issue I've got is everyone in my office, including myself uses Excel 2013 and form what I understand, Power Query isn't part of 2013 - I had to install it myself.
When the spreadsheet opens, code runs to refresh the table:
Code:
Worksheets("Validation").ListObjects("Validation_2").RefreshWhen someone else opens the workbook, it gives them the following error:
Which I assume is because Power Query isn't installed on their machine.
Does anyone know if there's a way round this, without me having to get Power Query installed on everyone's machine, which my IT team certainly won't do, lol.
Much appreciated.
Thank you.
Regards
Marhier
Last edited:
