196 questions with Microsoft 365 Insider | Excel | Windows tags

Sort by: Updated
5 answers

Create custom functions in Excel is not Working as Expected.

We have Microsoft Office 365 ProPlus Subscription(We have office 365 Enterprise E3). Version 1806(Build 10228.20021 Click-to-Run) Monthly Channel(Targeted). I have downloaded the Custom Function sample from…

Microsoft 365 Insider | Excel | Windows
asked 2018-06-20T16:32:14+00:00
Anonymous
12 answers

Python not available in Excel - Beta Channel

I've just successfully joined the Beta Channel and Office 365 has been updated. My Excel Version is 2311 - (Build 17022.20000 Click-to-Run) However un Excel under the Formulas tab - there is no Python section. Please advise

Microsoft 365 Insider | Excel | Windows
asked 2023-10-30T02:39:34+00:00
Anonymous
3 answers One of the answers was accepted by the question author.

Issue with the SEQUENCE() function

Hi, I am using Microsoft® Excel® pour Microsoft 365 MSO (Version 2501 Build 16.0.18407.20002) 32 bits. I have an issue inside a simple LET() function. I defined a "nbr" variable as a calculated array identical to {3,2,3,3} If I take…

Microsoft 365 Insider | Excel | Windows
asked 2024-12-16T07:50:40+00:00
Anonymous
16 answers

"Errors were detected while saving" but then "No errors found"

Over the past few weeks I've been getting a message when I try to save a file: Errors were detected while saving ... To make repairs in a new file, click Continue." I select Continue. Excel has me navigate back to where I want to save, and re-enter…

Microsoft 365 Insider | Excel | Windows
asked 2017-12-28T23:37:00+00:00
Anonymous
5 answers

Excel 2016 automatically hides workbook upon opening of a second workbook

Has anyone experienced strange behaviour from Excel 2016 version 1808 build 10730.20053 which includes workbooks being hidden automatically after opening another workbook?  This is sometimes followed by not being able to open or close other workbooks or …

Microsoft 365 Insider | Excel | Windows
asked 2018-08-30T12:29:02+00:00
Anonymous
1 answer

How to get office insider if you cannot see the same in Account option in Office 365 license?

I am using Office 365 but cannot see the functions GROUPBY and PIVOTBY in my version. On checking the same online, it is mentioned to shift to the beta channel from the current channel. However, I am not able to shift from Current channel to Beta channel…

Microsoft 365 Insider | Excel | Windows
asked 2024-06-20T07:17:55+00:00
Anonymous
1 answer

Python in Excel Preview not showing up

I've gotten on the Beta Channel and updated Office. The problem is that I can't still see the new Python feature on the Formula tab. What to do?

Microsoft 365 Insider | Excel | Windows
asked 2024-01-04T20:31:51+00:00
Anonymous
3 answers

FORMULATEXT error with MAP and/or BYROW

I have just installed the latest update in the beta channel of Office 365 and one of my formulas that I extensively use is not working. Have replicated it as follows: A1 = 1 A2 = 2 A3 = subtotal(9,A1:A2) A4 = map(A1:A3, LAMBDA(a, FORMULATEXT(a))) and I…

Microsoft 365 Insider | Excel | Windows
asked 2024-05-27T16:14:18+00:00
Anonymous
4 answers

Error message text when renaming a sheet in Excel

Hi there, I am using Office 2016 Insider Slow (Version 1702 Build 7870.2020) and I noticed following behaviour in Excel when renaming a sheet. When using Excel and renaming a worksheet, some characters such as *, /, [ or ] are not allowed. Excel just…

Microsoft 365 Insider | Excel | Windows
asked 2017-03-08T12:20:01+00:00
Anonymous
5 answers

Errors encountered while saving

When saving Excel encounters errors, see below: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <recoveryLog…

Microsoft 365 Insider | Excel | Windows
asked 2023-07-31T23:31:41+00:00
Anonymous
4 answers

Güncelleme ile gelmeyen özellik (EKLE/Onay Kutusu)

Herkese merhaba, Son güncellemeler ile "EKLE" menüsü altındaki "ONAY KUTUSU" bana gelmedi. Aynı sorunu yaşayan arkadaşlar var mı, sorun neden kaynaklıyor? ***Moved from Microsoft 365 and Office / Excel / For home /…

Microsoft 365 Insider | Excel | Windows
asked 2023-10-14T08:20:53+00:00
Anonymous
17 answers

why is my "focus cell" button not available?

I'm using Beta chanel of MS365 Insider, but "Focus cell" button is not available. What should I do to use this function?

Microsoft 365 Insider | Excel | Windows
asked 2024-10-03T06:53:35+00:00
Anonymous
3 answers

Are Excel Cell Controls (e.g. Check box) going to be a thing?

Jeff Lenning, a well known YouTube Excel guru, recently featured a very cool new widgetcalled a Cell Level Control in the Insert menu (not the Developer menu), in this case a checkbox, which seems to be a format overlay of a cell that stores a boolean…

Microsoft 365 Insider | Excel | Windows
asked 2024-03-08T19:41:47+00:00
Anonymous
11 answers One of the answers was accepted by the question author.

All my ActiveX controls are failing and being replaced with images. Anyone else having the same problem?

I'm on build 2311, but I don't see any discussion on this in the community, so I'm' wondering if maybe it's just my computer. I have written many VBA apps over the years and now all of them are failing because of the ActiveX controls I have in my apps. …

Microsoft 365 Insider | Excel | Windows
asked 2023-11-13T02:05:48+00:00
Anonymous
5 answers

Whatever happened to the Python IDE?

Everyone is talking about Python in a cell, but no one says a thing about the IDE. Was it dropped as a feature? I remember months ago all the screen shots of what the IDE was going to look like and the new menu items on the Developer tab, but there's…

Microsoft 365 Insider | Excel | Windows
asked 2024-01-24T10:10:39+00:00
Anonymous
11 answers

My Python formula on MS Excel is not working. I get an error #Blocked messge,

I am on Microsoft Insider Beta channel. I tried all option on the trust settings options but still with no luck. Any suggestions are appreciated.

Microsoft 365 Insider | Excel | Windows
asked 2024-01-16T23:28:29+00:00
Anonymous
1 answer

When is this going to be available in Office 365?

When is this going to be available in Office 365? https://youtu.be/pv0Eo55-SeI?si=b-eEv31uLOAfcPOH

Microsoft 365 Insider | Excel | Windows
asked 2024-07-01T13:48:30+00:00
Anonymous
5 answers

Python for excel beta. I get a ProxyError when I try to access the tiingo api using the python requests module.

This is the code I attempted to run: import pandas as pd import requests headers = {'Content-Type': 'application/json'} URL =…

Microsoft 365 Insider | Excel | Windows
asked 2023-09-14T18:57:15+00:00
Anonymous
25 answers

Get Data from Table/Range grayed out if cursor is in a legit Excel Table Build 1809

The Get & Transform icon to get data "from a table or range" is grayed out if the cell is in an Excel table. If it is in a non-table area, it converts to a table and loads, but will not let you load from a real table. You have to either…

Microsoft 365 Insider | Excel | Windows
asked 2018-08-16T00:36:08+00:00
Anonymous
6 answers

Python in Excel (Preview) error message appears with the trace ID is different: 687fc31bbcd642288977ca424718a311

Split from this thread. Hi All, I started with the first examples that is provided in the Python in Excel (Preview). The same error message appears, but the trace ID is different: 687fc31bbcd642288977ca424718a311 All four steps Glenn mentioned I have…

Microsoft 365 Insider | Excel | Windows
asked 2023-09-09T13:32:56+00:00
Anonymous