Windows 10: Find excel file that has array

Is there a way to search for an excel file that has an array?


ty.

:)

 

Microsoft Adds Dynamic Arrays and New Functions in Office Excel

Source: Dynamic Arrays and New Functions in Excel! - Office Insider Blog

Tweet



— Twitter API (@user) View on Twiiter

 

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

 

CSV files used to open in Excel....not now!

Hi, you say Excel is installed. Does it run normally?

You can't find Excel in (an unspecified) list of applications. I don't know which list that is for sure.

For example, in the list related to:
- rt click a file. Open With
- this list:



- this list:




- some other list...

If Excel does not appear in the above, I suggest you repair your office installation.

Maybe the above gives you some ideas. Otherwise please post a screenshot of where you think you should see it but don't. Thanks.