My excel file is linked to dbf file and my pivot table refreshes when the Dfb file is updated.
Now suddenly it stopped refreshing , seems like connection is lost, and error comes, "could not find installable ISAM"
I am using excel 2010.
In the properties under data connection, I checked the connection string which hasn't changed.
Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data
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
Please advise what could be the issue, I haven't change any program , it was working for the last few weeks without any problem now I can't refresh my pivots and can't establish any connection with the dbf file.
Thanks
Tk
Bookmarks