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

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

Modified on: Thu, 12 Apr, 2018 at 1:48 PM

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:

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

zip

DataPA.xla.zip

(30.4 KB)

Did you find it helpful? Yes No

Help Desk Software by Freshdesk

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

Related Articles