N
NervousFred
I have built an excel spreadsheet with a table in it that pulls data from an
access database. Both the database and the excel file are saved on my
company's server that everyone has access to. I created the excel sheet in 07
excel and am now read for the rest of my company to start using it. The only
problem is the rest of the company is on excel 03 and when I try and open the
spreadsheet on their machine's it asks me enable automatic refreshing or
disable it.
If you try to enable it, excel 03 gives several errors then won't update.
I am thinking it is a trusted locations issue in 03 becuase I know when I
created the spreadsheet in excel 07 I had make the database a trusted
location.
I have searched though excel 03 and can not find anywhere for a place to
make the folder that the database is in trusted. I only found a list of
trusted marco's and you could not even add new macro's, just remove them.
Any ideas?!
Thanks!
access database. Both the database and the excel file are saved on my
company's server that everyone has access to. I created the excel sheet in 07
excel and am now read for the rest of my company to start using it. The only
problem is the rest of the company is on excel 03 and when I try and open the
spreadsheet on their machine's it asks me enable automatic refreshing or
disable it.
If you try to enable it, excel 03 gives several errors then won't update.
I am thinking it is a trusted locations issue in 03 becuase I know when I
created the spreadsheet in excel 07 I had make the database a trusted
location.
I have searched though excel 03 and can not find anywhere for a place to
make the folder that the database is in trusted. I only found a list of
trusted marco's and you could not even add new macro's, just remove them.
Any ideas?!
Thanks!