Windows 10: PC Default Excel 2010 to newer Excel Windows 11

On Windows 11 the default spreadsheets app was switched to 2010 version of excel. When clicking on a spreadsheet file of any file type the the 2010 program opens but does not open with a spreadsheet just as gray and blank. The common fix is to go to Apps>Default apps>ExcelBut all of those file types have been updated to the Newer version of excel.There was something in properties or else where that was disabled for the 2010 version to work at all on the windows 11 PC.How does one restore the newer version of excel as the default program to open .csv .xls and others when the common fix is

:)

 

WP Excel won't open Excel 2010 Spreadsheets

I use Office 2010 (32 bit) on my Win7 Pro computer.

I have been using my Windows Phone 7.5 to open/edit Excel 2010 files stored on Skydrive for some time.

Suddenly, WP will not open the same files which it could open just awhile ago.

I have used Excel 2010 to edit these spreadsheets since the last time I opened them with WPExcel and saved them in the same format as before.

WPExcel states:

"Can't Open. Excel doen't recognize the file format "<filename"".

Yet these files open without issue with Excel 2010.

Any suggestions?



Update - WPExcel will open cloud Excel files that have not been recently opened by Excel 2010. Those files operate properly. However, once I open the same files with Excel 2010 and save them - WPExcel can not open them. Problem with Excel 2010?

 

Excel file

Hi zhiyang....,

I'm assuming that since you're using Excel 2011, that you have a Mac. Have you tried saving the file in the default 2011 format of XLSX?

While I have tested and can open both XLS and XLSX files on my Windows Phone, they were both created in PC versions of Excel 2000 and Excel 2010.

As a test, would you:

• First, try saving the file as XLSX and see if you can access the newer file format on your phone.

Otherwise, try the following as a test:

• Open up a web browser
• Go to Windows Live and login.
• Select "SkyDrive" at the top of the brwoser window
• Select the Excel icon near the top where it says "Create"
• Add a few numbers and do an AutoSum. Maybe add some formatting.
• Close the workbook (File -> Close workbook)
• Next, your SkyDrive file listing will appear with the new file.
• Click the "i" circle to the far right of the new file.
• Now, select "Send a link"
• Enter your e-mail information and click "Send"
• On your phone, open the e-mail and click on the button that says "View document"
• You should be able to view the document.
• If yes, then there is apparently a compatibilty issue on the Mac using XLS and I would try my first suggestion of trying to save the file in a different format like the newer XLSX.

By the way, the procedure gets easier in Windows Phone Mango (coming soon - no official release dates yet except in Japan) as you can save to and access files directly from your SkyDrive. That would eliminate the e-mailing it to yourself steps ... a lot easier!

I hope this helps!

David

 

Can't open file excel 2010 in multiple windows

In Excel 2010, all workbooks open within a single application window. Click Arrange All in the Window group of the View tab of the ribbon for options to arrange the workbook windows.

If you want to open workbooks in separate application windows, you will have to start multiple instances of Excel:

• Start Excel and open a workbook.
• Right-click the Excel icon in the Windows taskbar and select Microsoft Excel 2010 from the context menu.
• A new instance of Excel will start in a separate window. Open a workbook in this instance.

Warning: when copying and pasting between instances of Excel , you lose some features that are available when copying and pasting between workbooks in the same instance of Excel.