#62 Error 1004 on 1.33.1 & 1.33.2

[Douglas Terry]

I have confirmed on both v1.33.1 and now on 1.33.2 that every time I launch a comparison I get an error:
Error 1004 (Method 'ShowAllData' of object '_Worksheet' failed) in procedure CompareWorksheets of Form frmMain

This error is independent of whether I have any rows hidden as the result of filtering or not

[SteveT]

What version of Excel do you have?

[Douglas Terry]

Excel 2007 (12.0.6683.5002) SP3 MSO (12.0.667.1000)

[SteveT]

Okay. I am thinking that ShowAllData may have been added in Excel 2010 then. I will investigate. Mean time, you can comment that line when it occurs.

Thanks, Steve

[Epenco]

Hello
same for version 1.33.3 and Excel 2010 x86.
Error 1004 (Method 'ShowAllData' of object '_Worksheet' failed) in procedure CompareWorksheets of Form frmMain
Many sources say this error gets triggered when you try to remove autofilters from a worksheet where no filters are applied.
In such case, an "IF" would do the trick, by checking whether autofilters are applied or not before activating ShowAllData

Kind regards
E

[SteveT]

Think I fixed it now. The AutoFilterMode property should not have been in the existing code. Try v1.34.0.

Steve

[r.klein]

Unfortunately I also encounter this error message even in the newest version. So the reason seems to not have been found yet. Is there something I can do to still succeed using it to compare?

[r.klein]

I also still encounter this same error in the newest version. Is there anything I can do to still compare?

[Douglas Terry]

I have continued to use 1.32 because of this.

On Thursday, November 13, 2014 4:59 PM, r.klein romy1@users.sf.net wrote:

I also still encounter this same error in the newest version. Is there anything I can do to still compare?

[SteveT]

I have tried spreadsheets with no filter, filter enabled but showing all and filter enabled with data filtered and I cannot generate an error. Can you post a pair of Worksheets that exhibits the problem.

Thanks, Steve