I upgraded recently and am having a hard time setting up a workspace and saving it as I had done in the past on Excel 2007. A workspace enabled me to have two Excel files running at the same time, split on the screen, and able to be saved to a shortcut. I was able to launch the whole thing with two clicks. Is there a way to still accomplish this?
I don't think the concept of workspaces exists in recent versions of Excel. Each workbook now runs in its own window and you can arrange windows on the screen. You can open the two files, then select one, hold down the Windows key on the keyboard and press the Left Arrow. This will size the workbook to take up half of the sceen, aligned to the left. You can then select which window should take up the right half of the screen.