I have come across this with Details. I figured out that the Renovation Filter of the detail is set to the current renovation filter of the model (story, elevation, section, etc...) Example: I want my detail, which is an enlarged plan, to be on Planned Status Renovation Filter, so I go the source story of the detail, on the Project Map. While in the Source Story, I change the Renovation Filter to Planned Status. Then go back to the detail view, right-click and click on "Rebuild from Source View." This changes the detail to the Planned Status Renovation Filter. I would assume that Worksheets would do the same.
I hope this helps.
If anyone has an easier solution, let me know because this works, but is a pain sometimes.
Jeff