I want to show my Excel workbooks side by side, and when I click show windows side by side, the windows are getting shown in one frame. What can I do to be shown in two frames?
If you are using Excel 2010 View->New Window will allow you to open and update the same document twice so you can see multiple tabs at the same time. You will need to move/resize the windows mannually or select Arrange All and then it will resize for you. If using 2 different worksheets use the Arrange All and select Tiled/Horizontal/Vertical/Cascade.
What do you mean by "one frame"? IF you mean an instance of XL, this is the normal way XL works. IF you really want two different frames, you'll need to have 2 different instances of XL, which can have pros/cons. TO launch a new instance, run the Excel.exe file (Start - Programs - Office - Excel).