196 questions with Microsoft 365 Insider | Excel | Windows tags

Sort by: Updated
Updated Created Answers
1 answer

Copilot Function #BLOCKED in Excel Insider with MS365 Family License

I have a MS365 family plan and am an Insider - I can access the Copilot formula in excel however when running it I get #BLOCKED - is there something I need to setup here? In my account I have 60 available AI tokens...

Microsoft 365 Insider | Excel | Windows
asked 2025-10-29T14:08:57.62+00:00
Michael Wensley 0 Reputation points
commented 2025-10-31T08:11:27.63+00:00
Xavier-D 4,465 Reputation points Microsoft External Staff Moderator
1 answer

Was the Excel ribbon changed

I have kept a tremendous amount of personal data in Excel. The "ribbon" format seems to have changed requiring more key strokes for each operation. Why was this done?

Microsoft 365 Insider | Excel | Windows
asked 2025-08-08T17:23:04.0966667+00:00
Charles Sandra Mathews 0 Reputation points
answered 2025-08-08T23:46:58.62+00:00
Xavier-D 4,465 Reputation points Microsoft External Staff Moderator
1 answer

MS Excel not updating automatically

So recently you might be aware that the MS forms that are linked with Excel sheet is not getting updated automatically unless we manually open the sheet in Sharepoint. The workaround was to create a Power Automate flow where we can get response…

Microsoft 365 Insider | Excel | Windows
asked 2025-07-24T10:27:39.2133333+00:00
Punit Patnaik 0 Reputation points
answered 2025-07-24T13:28:15.6566667+00:00
Thomas4-N 8,940 Reputation points Microsoft External Staff Moderator
1 answer

Office Scripts unavailable. On web-based Excel, w/ Personal MS365 subsciption & Insiders program.

I was taking advantage of the Office Scripts on desktop-based Excel, without any problems. But I found that it is better to use it on web-based Excel along with Power Automate. So I tried the web-based Excel, but on there I couldn't find my Office…

Microsoft 365 Insider | Excel | Windows
asked 2025-07-24T07:17:43.8833333+00:00
rob0face 0 Reputation points
answered 2025-07-24T10:21:06.8366667+00:00
Thomas4-N 8,940 Reputation points Microsoft External Staff Moderator
8 answers

Excel 2203 & Oracle SmartView issue

Hello, I just noticed an issue with the use of Smartlists and member properties drop down lists in SmartView Planning Admin Extension since the last insider update (2203). Drop down and smartlists values do not show up anymore: instead I get 3 dots. I…

Microsoft 365 Insider | Excel | Windows
asked 2022-02-15T08:35:02+00:00
Anonymous
7 answers

#CALC error using xl() function with Python

Hi all, I have started with Python in excel, which I'm generally quite happy with. However, from one day to the other I suddently get a #CALC error when I use the xl() function to assign a range to a dataframe. The data range contains formulas and if I…

Microsoft 365 Insider | Excel | Windows
asked 2024-01-04T09:33:50+00:00
Anonymous
2 answers

When is Python going to be available in Excel for all users of Office 365?

I am a user of Excel Insider account, but I can't run the Python add-in within Excel.

Microsoft 365 Insider | Excel | Windows
asked 2023-09-01T14:11:19+00:00
Anonymous
3 answers

Python in excel shown in Formula but won't run

I have installed python, use an excel file in Onedrive folder but it just shows #PYTHON!.

Microsoft 365 Insider | Excel | Windows
asked 2023-09-15T19:52:19+00:00
Anonymous
1 answer

"Focus Cell" feature is not working if freeze panes is enabled !?

"Focus Cell" feature is not working if freeze panes is enabled !?

Microsoft 365 Insider | Excel | Windows
asked 2024-12-16T05:47:04+00:00
Anonymous
12 answers

Excel won't Save or Save as. Then it won't close.

Excel won't save or save as. It just says "Processing (press escape to cancel)" at the bottom of the window. It happens with any file I try. Excel then won't close. I have to use End Process Tree. Quick repair and re-starting does not…

Microsoft 365 Insider | Excel | Windows
asked 2020-05-28T18:59:17+00:00
Anonymous
7 answers

Python in Excel (Microsoft Insider Program)

I'd like to integrate Python in Excel. After joining the Microsoft 365 Insider-programma and selecting the beta channel, no function like =PY() is available in Excel, neither an icon of Python is visible in the ribbon under formula's. Any idea to realize…

Microsoft 365 Insider | Excel | Windows
asked 2023-09-01T12:29:55+00:00
Anonymous
2 answers

Immersive Reader not in Excel

Why can I not access Immersive Reader function in my Excel. I have Microsoft 365 and am a Beta channel member.

Microsoft 365 Insider | Excel | Windows
asked 2023-08-24T21:57:15+00:00
Anonymous
3 answers

Beta Channel - Add a Checkbox to a column in a table but checkbox is not in a new row and must be inserted again

If I create a new table and insert a checkbox in row 2 (row 1 has titles), adding a new row does not include the checkbox in the new row and must be inserted again. Any ideas on what I'm missing? Thanks.

Microsoft 365 Insider | Excel | Windows
asked 2023-12-11T20:04:11+00:00
Anonymous
8 answers

Excel crashing using some functions

Split from this thread. Hi, I am on Windows 10 (64bit), Office 2016 ProPlus (64bit). I am running Excel 2016 Version 1806 Build 10228.20051. I am on 'Monthly Channel (Targeted)'. I can open Excel and use it minimally, but whenever I try to do…

Microsoft 365 Insider | Excel | Windows
asked 2018-06-14T17:39:53+00:00
Anonymous
3 answers One of the answers was accepted by the question author.

Filter Function In Data Validation Not Working

Excel 1909 Build 12001.20000 August 2019 Using Filter() function. (=FILTER(Table4[Date],Table4[Value]<>0,"") Works great. Cannot use this same function and syntax as a source for a Data Validation (List). Currently, I can create a…

Microsoft 365 Insider | Excel | Windows
asked 2019-08-08T15:37:08+00:00
Anonymous
2 answers

Python in excel not available

Hello, I am a Microsoft 365 subscriber and I entered beta program from excel app. I followed instructions from help pages, and i didn't see 'python' related buttons in the formulas tab. I searched for python in the top bar, and clicked on 'insert python'…

Microsoft 365 Insider | Excel | Windows
asked 2023-09-05T10:11:54+00:00
Anonymous
2 answers

Python application is returning #Blocked error. It says I have exceed the daily quota of python usage.

Is there a limit on how much data can be used? I haven't seen any data limitation associated with the Beta Channel. I had no problem yesterday with the Python Add in. See screenshot below:

Microsoft 365 Insider | Excel | Windows
asked 2024-03-27T15:39:10+00:00
Anonymous
16 answers One of the answers was accepted by the question author.

Excel PT Slicer "Clear Filter" icon now always shows with red X

Office Insider, Excel, Version 1812 / 11107.20009 C2R When using a pivot table slicer, the funnel icon for "Clear Filter" now always shows the red X, whether a slicer selection is in place, or not. Previously it would be greyed out when the…

Microsoft 365 Insider | Excel | Windows
asked 2018-11-21T19:25:07+00:00
Anonymous
2 answers One of the answers was accepted by the question author.

VBA ProtectedViewWindow problem

Hello, I have some files from colleague which are from internet and Excel opens them under ProtectedViewWindow mode by default. but I need to do some batch work with VBA. the problem is I can't use "Workbooks.open" which would get error…

Microsoft 365 Insider | Excel | Windows
asked 2024-07-26T01:06:06+00:00
Anonymous
2 answers

Will Python in Excel be able to utilize OAuth2?

Hello! I just want to ask for the new 'Python in Excel' feature (which is to release soon), will I be able to make and utilize the OAuth2 standards and send HTTP Requests all in the cloud?

Microsoft 365 Insider | Excel | Windows
asked 2023-09-06T18:42:39+00:00
Anonymous