Re-apply Filter upon file open

[Magic_Man1]

A co-worker and I use a file that is linked to another data-file for automatic content updates. The non-data file has several filters and sorts applied. My co-worker can open this file and the file will automatically re-apply the filters and sorts without any macros, etc. Excel simply re-applies the filters when the file is opened. For some reason, my machine does not automatically do this. I was assuming this was a software setting. Anyone know how to set this up without a macro, etc?

Thanks,

[tony h]

On the face of it sounds wrong. But there must be a logical explanation. My initial guess is either you are opening different copies of the file or macros are running automatically for one of you and not the other.

1. is it the same physical file that is being opened (FBO) ? (I think the linked data file is a red-herring here)
2. Are there any macros in the FBO?
2a. Do you get an "Enable content" I think it says "content" and do you enable it
3. Is there a mischievous Leprechaun hiding under your PC