Excel Windows 10
Toni Jarels
I've got a problem with page breaks. My colleagues are working in Excel on a windows computer. When they open the document the page layout is OK. When I open the file on Excel for Mac (Iatest version) I have page endings on a different postion. Page breaks are inserted (solid blue lines). So instead of having everything on a page its spread over 2 pages. I can solve this but once saved my colleagues have this issue when opening it.
I want excel to open multiple spreadsheets in completely separate windows. I don't want to view side by side or anything I just want them to be on completely different windows. For example, when I hover over excel in my desktop taskbar, I want all of my spreadsheets to show. Thank you!
You can make changes in one window and Close it. Since it's just another view of the same file, no one will ask you to save (you have another window still open). Changes done in ne window will be automatically reflected on the other window.
Like Theo_Bear and and Nabil, your question is not totally clear to me either. If by "multiple spreadsheets" you actually mean "multiple workbooks", it sounds as if you want to know how to open each Excel workbook in its own dedicated instance, so they show up as such on your task bar as you mentioned. If that is what you want, this picture shows 2 methods for achieving that objective.
I suddenly had Office 2010 stop opening different Excel Files (ok worksheets) in their own instance, when they were doing it previously every time. Not sure what happened to make them stop doing it, but suddenly I could only view one at a time. If I went to File Explorer and double-clicked they would open and take the place of the one I was looking at. I can see there are 2 open only by looking at the task bar, where they are tiled. Your instruction to go to Start and then Alt-Click Excel did open a new instance and I can then view the to workbooks side by side as their own instance.
My Work laptop uses 365 in Windows 11 (yuck) after a recent upgrade from 10 got pushed out. However, it behaves like I want, and opens a new instance every time also. No, I don't open them in Edge. It's set to open in Desktop App. I did nothing to set the behavior, it has just always been that way. It's only my Win 7 Desktop that started this weird behavior.
I just upgraded to Windows 11. Now, when I opened my excel files in my QNAP NAS, excel showed document recovery message: "Excel has recovered the following files. Save the ones you wish to keep.". I tried to click the file to recover it but it has no response. Excel stopped there. I had to close Excel. I tried to reopen Excel and reopen the same file. It repeated. I could not open the file.
Initially, I suppose my excel file is damaged but I don't know why because I edited the file the night before. It had not problem. Finally, I copied the excel file from my NAS to my local drive in my laptop (i.e. the one I connected to my NAS). I opened the file in the local drive with Excel. It worked. I had no problem. Why?
@nsrumschlag I have exactly the same problem and it is related to the windows 11 install. All xlsx files now show with an IE symbol and will try to open in internet explorer (without success of course). The workaround is to right click on the file and select "open with" excel. That is necessary for all files with an xlsx extension. Files with an xls extension, however (older version of excel), show with the excel symbol and open directly. Once an xlsx file is open, saving it as a excel 2009 version with an xls extension solves the "open with" problem but some functions are obviously lost.
@Sergei Baklan Good Morning. I tried to add the .xlxs option to settings and set the default app to Excel however it still tries to open the file with Internet Explorer. Seems like an issue with Win 11 as I am not seeing this on a Win 10 computer at the same client.
@Sepharo I have tried the "Right-Click" and "Open with Excel", but it fails. I tried "xls" and "xlsx" files and neither will open. WORD works as it normally would. I can start Excel and it shows up to allow me to open a file. If I click on starting a blank new worksheet, Excel shutsdown. The ones I try to open show up in the "recently opened" list, but I still can't open any.
@rajuann check online for commandline parameters. I think "/e" as the one I tried. To do this, find the shortcut for starting Excel and add those two characters outside the quotes(I think), skipping my quote marks. Experiment. I don't have my laptop with me it the moment.
Since I have updated my PC to windows 11 Excel has not been working properly. Every 5 min the sheets seem to be unresponsive when I click on a tab or anywhere on the excel page. To make it work again I have to constantly reduce the window and reopen it. This is very frustrating as it happens very often. I have tried to start excel in safe mode or disable add-ins but the bug continues.
I don't seem to be the only person with who this is happening. A friend of mine is also having the same issue. Excel is my main tool of work and some days it is just unusable anymore where I have to reduce and reopen the window for every formula I am typing. I have tried to reinstall as well as repair Office several times but nothing seems to work.
Under windows 11, the mouse pointer in Excel occasionally does not work anywhere inside the excel sheet. Normally when you point it to an area inside the sheet the pointer turns to a cross to accept input. When it does not work, it stays as a pointer and no input is possible. When this happens, the following brings it back to life
I have three PCs that show this exact problem. Two were upgraded from Windows 10 (supported hardware and ungraded via the Windows upgrade channel), and the third is a new PC that came with Windows 11.
Sometimes, it is so bad and I can not work on any sheet, and almost every cell entry is frozen and needed to be brought back using the above two methods. I don't think the Microsoft help team knows what the problem is and thinks that online repair will fix it. Well, it did not and I think the problem is with Windows 11, not Excel.
I'm on Microsoft Excel for Microsoft 365 MSO (Version 2204 Build 16.0.15121.20000) 64-bit with Windows 11 and am still experiencing the same problems as you. It's intermittent but occurs regularly. I lose the ability to click on a cell to select it. Strangely, if I click the ribbon and wait for a tooltip to appear, the ability comes back and everything returns to normal. Sometimes I find it occurring if I hold down the right or left arrow keys to quickly move many cells at once.
Yes, same here I have spoken with Microsoft Help 4 times and they clearly do not understand what is happening or what the issue is. One of the times they even made my PC unusable, really disappointed by them...
Perhaps. However, when I fresh installed Windows 11 and installed only Office 365, the problem was there as well. Granted that there were pre-installed Dell software, but I don't think these were the culprits as my third PC is Microsoft Surface Book 3 with no such software installed and yet behaves the same way with Excel under Windows 11. I eliminated all the services that were running as possible, but was unable to eliminate the problem. So I believe that it is Excel 365 and Windows 11 not working well together, rather than other software or addin interference.
Whenever I copy paste special in excel, my excel file freezes and after a waiting for a few seconds to few minutes, depending on the amount of data being copy pasted, I get this error 'Microsoft Excel is waiting for another application to complete an OLE action'
IF the Azure Information Protection plug-In is there, it will be listed under Active Application Add-Ins at the top of the box. look down to the bottom of the open window where it says "Manage", and change that to "Comm Add-Ins", and press "Go". In the window that pops up, uncheck the Azure Information Protection plug in, and press "okay".
Thanks @Mauro_Gerber and @txnelson for the proposals. In my case "run program" did work after some correction of the path string (fileshare starting with // on windows 10), the proposal with "web" did not work, I tried several times, it looks elegant.
OK, actually, just before posting this I wanted to investigate it some more. I found an answer, and am posting it below. ...no need to upvote. I am just placing this here in case anyone else runs into this problem.
Edit: I am accepting Scott's answer, since I want to give him credit for an answer that could apply given a problem as described in my question, but please also read my answer, as it could also apply (and in my case it did apply.)
My universal method for a misbehaving window is using the Windows + UP-ARROW to maximize on the current display (or left or right arrow, if that's your style) and then pulling it down by its title bar, thus, switching to windowed mode again, then moving it to the desired spot.
There is a bug in Microsoft Excel that sometimes leaves a window displayed off screen where you cannot reach the top of the window to move it back into view. This can often be fixed by going to the "View" menu in Excel, click on "Arrange All" then switch the way that the windows are arranged. If it is in "Tiled" try "Horizontal" or switch it to a different mode. It doesn't seem to matter what it was or what you change it to, but this act of changing how the windows are arranged usually will clear up the mess and bring the window back into full view.
Our windows are constructed from two panes of A-rated glass separated by a layer of air. This structure better insulates your property with fewer draughts and noticeably less condensation in the mornings, as well as helping to insulate your home from outside noise. Double glazed units also provide a higher level of security for your home.
From near-invisible joints, the elegance of the run-through sash horn, to the curvy ovolo frame shape, these are just a handful of the many clever details that work together to create the most graceful and advanced sash window on the market.
03c5feb9e7