Microsoft 365 Insider Excel Windows

0 answers

Issues with Excel formula working and then not working

Hi all, Not sure where to start on this. First I'm on Windows 10 Pro x64 (1809) with all updates applied Office 365 Home (Insider) Version 1904 (11601.2004) Click to Run I have been having intermittent problems with formulas failing to execute…

asked

Anonymous

4 answers

Overloop error 6 bug during a multiplication in a macro

If one runs the following code an overloop error will occur during compiling of the VBA macro. This is a simple calculation. Why is this not calculated. This only happens during a multiplication. '---------- Sub test_not_ok() a = 12543 * 72 End…

asked

Anonymous

1 answer

Have lost access to GROUPBY and PIVOTBY functions

For the last 10 days or more. I used both functions for several months, but recently all I get is #NAME? error? I have 3 separate PCs on site, and they all behave the same. They are all on Insider Beta Channel v2407. In wizard, it shows:

asked

Anonymous

4 answers

Lambda Functions - Limit of Iterations

Greetings, I'm experimenting with the powerful Lambda Functions on Excel and stumbled into something I'm not quite understanding. Is there a limit of iterations to recursive lambda functions? I'll try to explain: I created a simple recursive lambda…

asked

Anonymous

8 answers

Excel crashes when user tries to Select Data for Chart

Right-clicking on a chart and clicking Select Data crashes Excel on the latest Insider build. Any ideas?

asked

Anonymous

4 answers

how i can join the microsoft 365 insider program

I am using Microsoft 365 Business Standard Version 2308(Build 16731.20234) i want to activate microsoft 365 insider program. Please help how to activate microsoft 365 insider program for Microsoft Office 365.

asked

Anonymous

12 answers

Data from Master Workbook to be shared (or collaborated) with a number of other workbooks

I have this Master Workbook, with a number of Worksheets and an enormous amount of Data. Now sections of this Data has to be used through other Workbooks (in many Departments) So lets say we have the Master Workbook and also Departmental Workbooks A, B,…

asked

Anonymous

11 answers

Not seeing the new check box feature in the Insert ribbon group.

Not seeing the new check box feature in the Insert ribbon group. I see this feature on some of the Youtube channels. Why is that? I do understand that I can add the checkbox feature by modifying the ribbon using a custom group but that does not…

asked

Anonymous

2 answers

Power Query Error in Excel 2016 Version 1807 Build 10325.20036

Hi there, I guess, the following is a bug in Power Query for Excel. I am currently using Excel Version 1807 Build 10325.20036. The Power Query Version is shown as 2.60.5169.161 (32 Bit) in the diagnostics section of the options dialog. For reproducing,…

asked

Anonymous

28 answers

Python in Excel feature is Enabled. But can't insert formula writing =PY.

I have enabled the "Python in Excel" module. but while writing in formula of any cell there is nothing named "PY" so can't code in cells.

asked

Anonymous

2 answers

Excel VBA: programmatically insert PY( ) call in worksheet cell?

Hi--In Excel, I need to programmatically insert a call to the interesting new PY( ) function in a worksheet cell, with return as an Excel value (not python object). Tried repeatedly using a few different ways, but all failed--see simple example below on…

asked

Anonymous

1 answer

Excel files with "manual recalculation", cells shown with strikethrough until recalculated. How can I deactivate this behavior???

asked

Anonymous

3 answers

Cell("Filename") returns URL rather than filename

Hello. I have had the below formula in a spreadsheet for quite some time now. The purpose of this formula is to determine the name of the Excel file that holds the formula. A table called "t_Parameters" holds the name of a subdirectory that…

asked

Anonymous

3 answers

Microsoft Visio Data Visualizer won't load in Office 365.

The new Microsoft Visio Data Visualizer Add In won't load in my Office 365 Excel app. What I get is a white box that says loading and then the Microsoft Edge opens with a blank screen.

asked

Anonymous

4 answers

Word and Excel restart automatically after I close them.

I am currently using the following Beta Channel release - Version2505 (Build 18812.20002 Click-to-Run) on Windows 10 (which is up to date). When I close the Excel or Word applications, they restart on their own without any intervention. I haven't tried…

asked

Anonymous

3 answers

Cannot find the 'Insert Python' function after installing and agreeing to M365 Insider

I'm trying to use the new 'Python in Excel' functionality, but the button for 'Insert Python' is not visible. (I cannot provide screenshots or upload files as it seems like that feature is not working on this forum at this moment) Here's what I've…

asked

Anonymous

1 answer

Office Keep Creating tmp Files when I Save It

Starting from Office Insider version 1812, a strange phenomenon I have faced several times: Office software, Word, Excel, PowerPoint keep creating temp files when I saving it, even I have upgrade into version 1901, 11128.20000, the issue still…

asked

Anonymous

3 answers

which Office program to use to make a diagram of a building interior?

I have the Office programs on my computer & need to use one to make a map or diagram of the interior of a warehouse? Will any of them help me with this?

asked

Anonymous

5 answers

Getting Copilot Preview on Excel

Hi everyone, i have followed the steps to add copilot preview on excel detailled here. I have also joined the Microsoft 365 Insider Beta channel. But i still cannot see copilot in my Excel. Can you help? Thanks!

asked

Anonymous

5 answers

Why can I not find Python in Excel for Microsoft 365 Family subscription?

I subscribed to Microsoft 365 family. But Insert Python function is not available in excel. Formerly, I was using Microsoft Office Home and Student 2021. I already have uninstalled Office 2021, downloaded and installed 365, but still, Python in excel is…

asked

Anonymous

Microsoft 365 Insider | Excel | Windows

Filter

Content

196 questions with Microsoft 365 Insider | Excel | Windows tags

Issues with Excel formula working and then not working

Overloop error 6 bug during a multiplication in a macro

Have lost access to GROUPBY and PIVOTBY functions

Lambda Functions - Limit of Iterations

Excel crashes when user tries to Select Data for Chart

how i can join the microsoft 365 insider program

Data from Master Workbook to be shared (or collaborated) with a number of other workbooks

Not seeing the new check box feature in the Insert ribbon group.

Power Query Error in Excel 2016 Version 1807 Build 10325.20036

Python in Excel feature is Enabled. But can't insert formula writing =PY.

Excel VBA: programmatically insert PY( ) call in worksheet cell?

Excel files with "manual recalculation", cells shown with strikethrough until recalculated. How can I deactivate this behavior???

Cell("Filename") returns URL rather than filename

Microsoft Visio Data Visualizer won't load in Office 365.

Word and Excel restart automatically after I close them.

Cannot find the 'Insert Python' function after installing and agreeing to M365 Insider

Office Keep Creating tmp Files when I Save It

which Office program to use to make a diagram of a building interior?

Getting Copilot Preview on Excel

Why can I not find Python in Excel for Microsoft 365 Family subscription?