I am using excel 2010, my excel file connected to dbf file and excel file has my pivot tables based on the dbf file and once the dbf file is updated I refresh the excel file and all the charts are updated.
I opened this file in excel 2016 and saved it , and now I cannot refresh any data in excel 2010 and error message comes COULD NT FIND INSTALLABLE ISAM, looks like the connection string settings are changed and I don't know how to fix them.
Please advise what settings needs to be changed so that it can work in excel 2010
Settings are :
Source=\svrau085ssm00.oceania.corp.anz.com\khant$\My Documents\SAS;Mode=Share Deny
Write;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet
OLEDB:Engine Type=18;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk
Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet
OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy
Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet
OLEDB:Support Complex Data=False;Jet OLEDB:Bypass UserInfo Validation=False