When you’ve got a file open with multiple pages, do you need to “save” separately on each page, or will saving on any page save on all?
TIA.
When you’ve got a file open with multiple pages, do you need to “save” separately on each page, or will saving on any page save on all?
TIA.
If you make a change on worksheet A, then switch to worksheet B before saving, the save affects all worksheets.
Great, thanks. I started feeling stupid saving on each of the three pages when I couldn’t remember which one(s) I’d done changes on.
Now give us a good one, twicks - that one was too easy.

something about forms driving offsets that have data sets pulling from a larger dataset to create user customizable graphs would be nice…
Is that English?
That actually sounds fun.
I’m sick ![]()
For niblet_head: picture a graph with drop-down boxes (or input fields) where a user would select (or enter) the subset of data that he wants to see in the graph. Pretty useful stuff, actually. Behind the scenes, you might have an intermediate range (that the graph references as its data set) which is comprised of various OFFSET() and MATCH() functions that reference the user forms and pull in the data from the main data set that the user is interested in.
The only stupid question is the one not asked.