excel file

i have opened two worksheets (excel 2010) and minimised them . but when i maximise and select to open one file and try to open the other one everytime it opens the same file.
kurajeshSenior Systems AnalystAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

can you describe in a bit more detail, please? What did you minimise? The Excel application or the file window(s) within the Excel window?
What do you mean by "maximise and select to open"? If the files have been minimised, they are already open, and you don't need to open them again.

If you have several Excel files open and click the minimise icon for the FILE (not the Excel application), -- see the screenshot: the red square shows the icon to minimize the file window --

 minimise options
then you will most likely see this:

The file window that you clicked the minimise icon will be minimised and will have an icon at the lower left hand corner of the Excel window.

All other files will be "restored" to their previous, non-maximised window size. If any of the files were minimised before, they will also be positioned as an icon in the lower left of the Excel window.

So, all previously minimised files will appear like this:
 minimised files
All files that were NOT mininmised, will be in a "restored" window, which you can resize to suit or minimize by clicking the _ icon in the file window upper right hand corner.
 restored windows
Excel remembers if a file was minimised or restored. As soon as you change any single file window from a maximised state, ALL files will be returned to their previous state. The only exception is the file that was clicked out of the maximised state. If you click the minimize icon, then it will be minmized. If you click the restore icon, then it will be restored.

All other files in the same Excel instance will revert to their previous unmaximised state. If they were previously minimised, they will be minimised. If they were previously restored, they will be restored.

Note: in this context, "restored" means a non-maximised window with a height and width that has been determined by the user by dragging the window borders or accepting the Microsoft defaults.

Hope that helps.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
I feel pretty bad for mixing "-ize" and "-ise" words in the post above, but at this hour of the night, I'm afraid I just don't care about the spelling differences between UK/NZ and US.
kurajeshSenior Systems AnalystAuthor Commented:
i mean to say

1) i opened a file a.xlsx from my dekstop and minimised
2) opened another file b.xlsx as well and minimised.

now both are in the taskbar. if i select a.xlsx it opens but evenif i select b.xlsx it opens a.xlsx again and not b.xlsx  

hope now i made it clear

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.