When i am opening an Excel file, each excel sheet is opening in a separate workbook.
Why it is opening like that and how to control it
When i am opening an Excel file, each excel sheet is opening in a separate workbook.
Why it is opening like that and how to control it
nflsales,
You saved the workbook with multiple windows opened at one time. It's a feature in Excel that allows the user to use multiple windows for the same workbook.
View > New Window
All you have to do is close the other windows and then re-save the workbook. To view the windows that are opened do:
View > Switch Windows
For Excel 2003 the path might be different then what I gave you. I'm using 2010+.
Last edited by BrownBoy; 05-31-2014 at 01:35 AM. Reason: didn't see version
BrownBoy
If happy, mark "SOVLED" & add to "REP"
Thank you Mr BrownBoy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks