So I used pivot table in excel, where its source is a table on access. So, the Access file is in a server. The Excel file is in Dropbox. When I open the Excel in the dropbox, in another computer, when I refreshed it, it told me: "Could not find installable ISAM.". But when I opened the exact copy of the Excel file that located in the same server (and folder) as the Access file, it worked (could be refreshed). And it's done on the same computer.
The Connection String:
There must be the a million post/thread about this, but when I tried to read it, since I don't even undertand how the connection worked, I didn't understand what people talking about. When I was importing the table, I just opened 'DATA' tab, then choosed 'From Access', and from then just 'Yes', 'yes', 'yes' (and, surely, choosed which from which file and table to be imported).
So, what's the cause and how to fix it?
Bookmarks