I searched and did not find an answer to what I am trying to do. If I missed it, thank you in advance for the link to it.
Over the years, I created a kind of dashboard (excel 2003). Where I have 4 key worksheet views, all opened at the same time, filling my entire screen so I can view them all in their strategic location (different sizes, etc). When I created it, it was nice, I clicked to close and it closed all and when I opened it, I saw all 4 worksheets in the right location in the same window.
Then the next version of excel (7 or 10), they made me close each worksheet opened one at a time, which was annoying, especially if I forgot to save it, because it didn't ask me about saving it until I was closing the last window, so if I saved at that point I would lose the 3 other open worksheet views or if I didn't save, I would lose all the work I just did. I learned to deal with it and save a lot.
Now Excel 2013, opens all 4 views in 4 different worksheets and stacks them each time. I now will have to re-size and re-position them each time to be in the right location on the screen. This just isn't going to work and I am very disappointed. I use this spreadsheet all the time and having to spend 5-10 min to set it up each time I open just makes no sense. In a perfect world it would go back to 1 view and one x to close. I am looking for any help to find a work around.
BTW - I am far from an excel expert, I have better skills then most my friends, but that's just from trail and error over the years. All help GREATLY appreciated.
Over the years, I created a kind of dashboard (excel 2003). Where I have 4 key worksheet views, all opened at the same time, filling my entire screen so I can view them all in their strategic location (different sizes, etc). When I created it, it was nice, I clicked to close and it closed all and when I opened it, I saw all 4 worksheets in the right location in the same window.
Then the next version of excel (7 or 10), they made me close each worksheet opened one at a time, which was annoying, especially if I forgot to save it, because it didn't ask me about saving it until I was closing the last window, so if I saved at that point I would lose the 3 other open worksheet views or if I didn't save, I would lose all the work I just did. I learned to deal with it and save a lot.
Now Excel 2013, opens all 4 views in 4 different worksheets and stacks them each time. I now will have to re-size and re-position them each time to be in the right location on the screen. This just isn't going to work and I am very disappointed. I use this spreadsheet all the time and having to spend 5-10 min to set it up each time I open just makes no sense. In a perfect world it would go back to 1 view and one x to close. I am looking for any help to find a work around.
BTW - I am far from an excel expert, I have better skills then most my friends, but that's just from trail and error over the years. All help GREATLY appreciated.
