J
Jimmy G
I have exported the data from an Access query into Excel, but I want the data
to refresh whenever the Excel spreadsheet is opened. However, the "Refresh
Data" button is greyed out. I've tried to Import Data from the Excel side,
but message I get is that I do not have permission to access the Access query
data. I do need to use a password to open the Access program and I'm
wondering how I can allow any user to open the spreadsheet and see the
spreadsheet with the most recent data (which is only refreshed every 24
hours). What do I need to do to resolve this issue? Help!
to refresh whenever the Excel spreadsheet is opened. However, the "Refresh
Data" button is greyed out. I've tried to Import Data from the Excel side,
but message I get is that I do not have permission to access the Access query
data. I do need to use a password to open the Access program and I'm
wondering how I can allow any user to open the spreadsheet and see the
spreadsheet with the most recent data (which is only refreshed every 24
hours). What do I need to do to resolve this issue? Help!