Hi everyone.
Been viewing the MrExcel boards for some time now and have always been able to find an answer to what I'm looking for but this time I'm completely stumped. I've searched the forum and googled it but can not find an answer or anyone else experiencing the same problem.
Using Excel 2003 (SP2) and Windows XP (SP3)
I have a spreadsheet with data in A1:DK15208. The sheet has panes frozen at E13 and an autofilter on the whole of row 12 (A:DK). This spreadsheet is used as a template which is populated with data from other sources via VBA and produces an output report. A while ago I ran one of the reports but when I opened it up the autofilters did not appear to be working although the drop down arrows were being displayed. I went into the template and the same thing was happening - the autofilter drop down arrows are all showing on row 12 but none of them work and in Data>Filter the Autofilter option is available. If I select row 12 then turn autofilter on then it works fine, but when I turn it off again the drop down arrows are still there. If I select another region (say row 10) and put the filter on then another set of autofilter arrows appear and BOTH the autofilters start working.
This is affecting all the autofilters on each sheet in the workbook so I'm thinking it's maybe a global setting/issue somewhere?
If I select row 12 and turn autofilter on then save the file, the next time I open it the filter arrows are still showing but have stopped working and the autofilter option is unticked again.
This has also happened on a number of other spreadsheets we use and I have gone through all the code (workbook, sheet and module) and there is nothing I can see which would cause this behaviour. I wrote the code myself and the file is read-only so no-one else could have messed with the file. I tried copying the sheets to a new workbook but the problem persists.
Any ideas on what is causing this or how I can stop it?
Thanks in advance!!
Been viewing the MrExcel boards for some time now and have always been able to find an answer to what I'm looking for but this time I'm completely stumped. I've searched the forum and googled it but can not find an answer or anyone else experiencing the same problem.
Using Excel 2003 (SP2) and Windows XP (SP3)
I have a spreadsheet with data in A1:DK15208. The sheet has panes frozen at E13 and an autofilter on the whole of row 12 (A:DK). This spreadsheet is used as a template which is populated with data from other sources via VBA and produces an output report. A while ago I ran one of the reports but when I opened it up the autofilters did not appear to be working although the drop down arrows were being displayed. I went into the template and the same thing was happening - the autofilter drop down arrows are all showing on row 12 but none of them work and in Data>Filter the Autofilter option is available. If I select row 12 then turn autofilter on then it works fine, but when I turn it off again the drop down arrows are still there. If I select another region (say row 10) and put the filter on then another set of autofilter arrows appear and BOTH the autofilters start working.
This is affecting all the autofilters on each sheet in the workbook so I'm thinking it's maybe a global setting/issue somewhere?
If I select row 12 and turn autofilter on then save the file, the next time I open it the filter arrows are still showing but have stopped working and the autofilter option is unticked again.
This has also happened on a number of other spreadsheets we use and I have gone through all the code (workbook, sheet and module) and there is nothing I can see which would cause this behaviour. I wrote the code myself and the file is read-only so no-one else could have messed with the file. I tried copying the sheets to a new workbook but the problem persists.
Any ideas on what is causing this or how I can stop it?
Thanks in advance!!
