196 questions with Microsoft 365 Insider | Excel | Windows tags

Sort by: Updated
3 answers One of the answers was accepted by the question author.

Refresh All not following query property settings

I'm using a template I built about a year ago...  little has changed except for excel's behavior regarding refreshing queries.   I have 28 queries in total.  Some are set to "refresh this connection on refresh all".  Some are not set to do so…

Microsoft 365 Insider | Excel | Windows
asked 2020-08-03T21:47:46+00:00
Anonymous
6 answers

The New Insert Picture In Cell Feature

Hi, I am part of the MS Insider Program and I have asked for the Beta version to be installed on my machine. Any idea why the new Insert Picture in Cell feature isn't part of it when I saw some MVPs are already using it in the Beta version please? …

Microsoft 365 Insider | Excel | Windows
asked 2023-08-31T13:40:56+00:00
Anonymous
6 answers

Are there are any reported problems with Excel formulas in Beta, particularly with the YEAR function or VSTACK and HSTACK?

Are there are any reported problems with Excel formulas in Beta, particularly with the YEAR function or VSTACK and HSTACK? I have been attempting to follow a YouTube video "How to make a CALENDAR formula in excel | LAMBDA" created by Karina…

Microsoft 365 Insider | Excel | Windows
asked 2024-06-07T17:14:43+00:00
Anonymous
2 answers

Where is pivot by function

I am running office 365 on windows 11 and am a member of insider. I hear a lot about the pivot by function, but it is not in my formulas as available. I have updated the software, but still can't see it - i am in Australia. Any suggestions, i would…

Microsoft 365 Insider | Excel | Windows
asked 2024-03-29T05:13:00+00:00
Anonymous
4 answers

Stock Data - Symbol lookup syntax

Hello, Can you please clarify the syntax to use when entering a stock symbol and you wish to specific the exact source where the symbol is listed? It is great that there are multiple data sources for the stock symbol information in Excel, but it can be…

Microsoft 365 Insider | Excel | Windows
asked 2018-09-18T11:26:45+00:00
Anonymous
4 answers

#CALC

I have data with around 20,000 columns and if i try using python to import the data i am getting a #CALC error. see below

Microsoft 365 Insider | Excel | Windows
asked 2023-09-06T16:57:24+00:00
Anonymous
3 answers

How can I get access to Copilot in Excel

I've read multiple times on the forums that it's "available," "it's region locked," "it's not region locked but regionally available to certain users" but cannot find a definitive answer anywhere. Please, can I get some…

Microsoft 365 Insider | Excel | Windows
asked 2023-11-17T21:35:27+00:00
Anonymous
1 answer

Excel 365 - Python installation

I cannot install python in excel and you have requested the following: " Hi Christos Kagkileris , Thank you for trying the recommended steps. If it is really not letting you go through, then possibly there's an issue on your current build. Please…

Microsoft 365 Insider | Excel | Windows
asked 2024-03-30T17:52:52+00:00
Anonymous
3 answers

Cannot undo circular formula error

I have a spreadsheet with a circular formula reference (I know, circular refs are nasty, but it's for a client that does some pretty heady accounting stuff and they insist it is necessary to do things this way). They have Auto-Calculate and Iterative…

Microsoft 365 Insider | Excel | Windows
asked 2018-07-15T20:05:57+00:00
Anonymous
1 answer

MS Office suddenly lag and slow when moving the window

Hi, I want to ask how to fix this problem that all MS Office just slower that last week. I just move the window of MS Excel to another mornitor (dual) its very delayed to moving. This just happened on Monday (yesterday) Again, this is not only Excel its…

Microsoft 365 Insider | Excel | Windows
asked 2018-07-23T23:52:46+00:00
Anonymous
24 answers

XLOOKUP in Excel not available

Hi, I'm on the InsiderFast update in Excel, and my current version is 1910 (Build 12030.20004) Why is XLOOKUP not available? Something I need to do? When i try to update, it says I have the latest version. Regards Marius Sv

Microsoft 365 Insider | Excel | Windows
asked 2019-09-04T21:42:42+00:00
Anonymous
1 answer

Excel 365 vs excel 2010

I created and worked for years on excel workbooks using office 2010 /XP, the files having the extension ...xlsx, and having data far beyond 256 (IV) columns by 65,536 rows Now on the new surface pro with Excel from office 365 / Windows 10, I can…

Microsoft 365 Insider | Excel | Windows
asked 2017-10-01T14:20:42+00:00
Anonymous
3 answers

Limits of Python implementation in Excel 365

Hi all, we are testing the beta feature of Python in Excel 365. It appears that the python code is running on servers in Azure. So there is no local python running on my PC. I have been trying to use python code to connect to SQL DB, but i get odbc…

Microsoft 365 Insider | Excel | Windows
asked 2024-01-31T08:22:15+00:00
Anonymous
4 answers

How do you install Tkinter / CustomTkinter so that they are usable within Excel ?

I tried the Tkinter/CustomTkinter GUIs packages with native Python via the "pip install xxxxx" command but they are not accessible within Excel. Is there a specific library to run the "pip install xxxx" command ? Thanks for your…

Microsoft 365 Insider | Excel | Windows
asked 2023-10-19T00:33:54+00:00
Anonymous
5 answers

DROP DOWN LIST WITH SEARCHABLE OPTION

I recently became a beta version user after using merely 365 version for quite a while. I was trying to do DROP DOWN LIST WITH SEARCHABLE OPTION, it didnt work fully. Drop down list is working but it is NOT SEARCHABLE. What could be the problem?

Microsoft 365 Insider | Excel | Windows
asked 2022-01-27T18:51:29+00:00
Anonymous
16 answers

Conditional Formatting Box Cut Off at Right Side

Like the Subject Line says, the CF box is cut off. I can't grab a corner handle and re-size. This means I can't edit which cells my formulas go in. Version 2010 Build 13328.20000 CTR Win 10 Pro V 2004 OS Build 19041.508

Microsoft 365 Insider | Excel | Windows
asked 2020-10-01T23:35:23+00:00
Anonymous