This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am training on an advanced class for working this program, but for several data across workbooks functions I need to see all 4 workbooks at once. THe Arrange ALL function in tile mode so I can see all 4 workbooks simple takes the workbook I accessed it from and makes it a smaller window without adding the other open work books. ALSO often when I try to open a 4th Workbook it tells me I cannot.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi Shauna,
I’m writing this reply to follow up this case, may I know if you have checked my last reply? When you have time, you are welcome to come back to let me know if your still need help here.
Hope you are all well during this period, stay safe and have a nice day 😊
Best Regards,
Arck
Hi Shauna,
Thanks for using Microsoft products and posting in the community, I'm glad to offer help.
Generally, when 4 workbooks are opened and go to View tab > Arrange All > select "Tiled", they will be displayed tiled on the screen at the same time.
Reference: Compare two or more worksheets at the same time
According to your description, I'm sorry I cannot understand your situation very well, do you mean that the fourth workbook cannot be displayed normally like the picture above?
To better understand your situation, could you please describe the specific steps on your side in detail? And please provide the screenshot if there is any prompt, your understanding and cooperation will be highly appreciated.
Looking forward to your feedback.
Best Regards,
Arck
Hi Shauna,
Sorry for the late response due to out of office.
It seems that you may need to perform an online repair to fix the program, please go to Control Panel or Windows settings > Apps & features to repair your Office: Repair an Office application
Best Regards
Arck
When trying to work in multiple worksheets I sometimes get an error window when trying to open the fourth worksheet. But if I manage to get them all open and then go into one and select View, then Arrange All and Tiled, it soes not displybas shown. It creates one small window with just the original workbook. If I manage to get that expanded to shows that workbook in the upper left but the others are not there. When I look at my task screen they are all shunken the same way but not on the same screen.