When I run a query in Excel, I get the error "Run-time error '1004': Method 'Visible' of object '_Worksheet' failed".

Applicable Versions: 2.03.0137 and Earlier

With some installations of Excel, an attempt to show or hide a worksheet from an AddIn failed with this error. Version 2.03.0137 and earlier did not cope with this error.

To resolve this error, download the attached zip file that contains DataPA.xla. On the target machine, follow the instructions below:

1. Close all running instances of Excel.
2. Search for all instances of the file DataPA.xla on the machine, and replace with the attached file.