Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have been attempting to figure this out for weeks, to no avail. I have several sheets and I am using the alternate states as much as I can, however; all 3 sheets are changing according to the 1st sheet, and the alternate states that I have set. I do want the chart on sheet 3 to change, but, I want it to only change for 2 of the filters not the 3rd filter, because I want all of the facilities to still show, instead of disappearing.
Anyone please help, how can I do this? Thank you.
It sounds like your States are not assigned correctly to all the objects. Please be sure to assign the correct states to the right objects on a sheet. If filters are the issue, copy these and assign a different state to these.
Hope this helps.
It sounds like your States are not assigned correctly to all the objects. Please be sure to assign the correct states to the right objects on a sheet. If filters are the issue, copy these and assign a different state to these.
Hope this helps.
Thank you, that was the issue.
Sincerely,
Barbara Jackson