Axolot Data

I beg your pardon: perhaps I wasn't terribly clear in my earlier post. I recommended changing, not PictureName, but the picture's filename. This multiplies the number of picture files, of course; but these renamed files will normally be in a temp directory, or can be controlled programmatically.

Don't know if this is still any use to you, but: the trick is to give the picture a different name for each sheet. You may wish to use a timestamp, or simply add a serial number; personally, I just add the sheet number to the filename.

Please let me add my vioce to this, since this is a fairly serious problem for us. Autofilter works exactly as expected in Excel 2007 (which meant that we didn't spot the problem initially); but in earlier versions of Excel (97 to 03) it behaves as described earlier: all filter buttons look as thoug...