Excel topics

How to add another criteria to FILTER function

Tinny426 — Wed, 09 Sep 2026 23:54:15 GMT

Hi all, I am using the FILTER formula in my spreadsheet and i need to have two criteria "J" and "jj". How do I modify this ? !B3:B241="J"

Stockhistory function not updating since 7th September

VivekJJ — Wed, 09 Sep 2026 15:56:49 GMT

The historical data of stocks is not getting updated after 7th September, how to fix it.

Please help

I want to use Ctrl+Shift+Enter in Excel 365.

bo32da — Wed, 09 Sep 2026 15:00:32 GMT

In Excel 365, I want to enter an array constant using Ctrl+Shift+Enter. But it doesn't work.
Since I’m preparing for a certification, I need to enter the array constant using Ctrl+Shift+Enter so that it is recognized as the correct answer.
Please help me!😭

Office 2016 pro plus - XL copy paste is not functioning (no issue with MS Word)

MRizwanKhan — Wed, 09 Sep 2026 12:06:23 GMT

after updating my windows 10 x64 and office 2016 professional plus, ms xl copy/paste is not functioning as usual means No Paste. even Esc is not working to get out of copy/paste mode.

geopandas no python for excel

anhambombe — Tue, 08 Sep 2026 22:40:07 GMT

When will Python for Excel support mapping libraries such as Geopandas?

planilha excel corrompida

edimarcos — Tue, 08 Sep 2026 18:58:11 GMT

boa tarde, atualmente uso uma planilha em excel no meu notebook que a mesma é compartilhada no google drive, porém ao realizar a ultima modificação

e ao tentar abrir ela no dia 08/09 o arquivo nao esta abrindo, aparece a mensagem erro de arquivo ou extenção verifique, estranho que ao clicar em propriedades ela aparece como 0 bites.

OBS NÃO É POSSIVEL ABRIR ARQUIVO

Add ins have disappeared and unable to add them back

Flybr1dge — Tue, 08 Sep 2026 13:58:35 GMT

The Add Ins have disappeared. I click the Add In logo then click on the Add button, enter the namer of the Add In I want and I get a message saying it is unable to load any Add Ins.

What is happening? How can I get my add ins back?

Thanks

Steve

Webservice function

PiotrMirowski — Mon, 07 Sep 2026 10:53:15 GMT

Hello.

I want to use the WEBSERVICE function to geolocate an IP address. The address is in cell A1, and the function is in A2. The function looks like this: =WEBSERVICE("https://ip-api.com/csv/" & A1). Unfortunately, the result is #ARG!. I have no idea what is wrong. Can you help me?

Best regards,

Piotr

Linked data not updating

LindaBee05 — Mon, 07 Sep 2026 08:36:34 GMT

Hi I have a rostering spreadsheet where each person has their own spreadsheet with their rota they select a shift in their spreadhseet. I have a main spreadhseet

where I link each spreadhseet to my my main rota so I can see what shifts they have selecteeneed and be able to resolve any conflicts i.e 2 peole selecting sam eshift. The issue is when data is updated in the individual spreadhseet it is not pulling through to my main spreadsheet. I used Data and get data form Excel file to link the workbooks. Not sure what I am doing wrong

When Dr Adams adds a Y in Thursday it is not showing in my spreadhseet

Referenced cells do not identify themselves with color

greyes — Fri, 04 Sep 2026 15:04:07 GMT

For some reason when I create a formula that references other cells, I cannot get those cells to "identify" themselves with a specific color. For example, in the image below the formula references cells B7, B8, B6, etc but they are just black text and don't show up in color per standard excel documents. Usually they "glow" with a specific color so you can find them easily in big spreadsheets. How do I get the colors back?

Automatic change of background color in Excel

Ashnarug — Wed, 02 Sep 2026 11:19:38 GMT

How can I prevent the background color to change automatically when I enter an identical number in a second cell ? I tried the "no fill" but that does not work at all.

Microsoft 365 version 2608

Please Help_ Disappeared Excel Doc

202627 — Wed, 02 Sep 2026 00:09:59 GMT

Dear Expert,
I just lost my Excel Document that improved after I have downloaded from the Chat GPT. I have improve many different sheets on the documents but it is now only see the excel sheets that I made yesterday. I can only see the last page I improved today.

Please help me.

Little blue circles

GeoffDavis — Sun, 30 Aug 2026 23:46:24 GMT

These little solid blue circles with me initials in white keep popping up at random in my spreadsheets. How do I get rid of them?

Advanced Filter

BaltaD — Sat, 29 Aug 2026 14:22:16 GMT

Hello.

I created a filter that has 2 conditions. 1. If the Ref Cert or the SK Cert is YES, bit should appear. The problem is that if the columns with Ref Exp or SK Exp is blank, then it gives me a 0 or if it does have a date, then it gives me the number equivalent. The original table, it does have dates. I tried to format the columns so it would give me an actual date, but it doesn't work. It only works for the blank cells.

This is the actual formula.

=FILTER(C3:N500,((H3:H500)="YES")+((J3:J500)="YES"))&IF(ISBLANK(I3),"",I3)

Array is C3 : N500 (This is the table where is information is coming from)

Ref Cert is H3 : H500

SK Cert is J3 : J500

This is what the finish product looks like.

When #VALUE! isn’t an error: The hidden reference behavior of Excel’s dynamic arrays

FredAlves — Fri, 28 Aug 2026 20:02:25 GMT

1. Mechanism Overview

Functions such as TAKE, DROP, OFFSET, and INDIRECT normally produce a range when supplied with scalar parameters. When instead a 1-D or 2-D numeric array is passed to one of these parameters, Excel attempts to generate multiple range outputs (one per array element). Since Excel’s grid architecture does not allow a single function call to return multiple ranges in parallel, the function fails. The visible result is an array filled with #VALUE!.

Example patterns:

=TAKE(range, {1;2;3;4}) =DROP(range, {1;2;3;4}) =OFFSET(range, {1;2;3;4}, {1,2,3}) =INDIRECT("A1:B"&{1;2;3;4})

Excel returns:

{ #VALUE!; #VALUE!; #VALUE!; #VALUE! }

Although the values appear identical, each #VALUE! is associated with a distinct internal range reference corresponding to the attempted slice, offset or address.

This is a side effect of Excel’s reference-binding layer, which attaches metadata to #VALUE! propagation structures when a reference-producing function fails after partially resolving its operands.

2. Behavior Characterization

2.1 Reference Retention

Each #VALUE! error produced by the above functions contains a deferred reference representing the range the function attempted to construct.

The reference is not materialized because:

a multi-range return is not allowed, and
the evaluation is aborted at the final conversion stage.

However, the binding phase (operand resolution) has already created a reference object. This object is preserved internally and passed forward along the calculation chain.

2.2 Deferred Evaluation

Functions that inspect operand values (e.g., SUM, MIN, COUNT) cannot extract data from these encapsulated #VALUE! tokens and will propagate the error.

Functions that inspect operand references — such as MAP, SCAN, REDUCE, MAKEARRAY, and aggregation functions that re-evaluate their inputs individually — trigger evaluation at the point of consumption.

Example:

=MAP( TAKE(range, {1;2;3;4}), SUM )

In each MAP iteration:

ref is a #VALUE! carrying an unresolved range reference.
SUM(ref) requests value-level evaluation of that range.
The reference is resolved at that moment only.
The resulting scalar is passed downstream.

Thus, the #VALUE! error acts as a strict thunk.

3. Functional Implications for Formula Construction

3.1 Range-Object Semantics

The technique enables modeling of ranges as first-class reference structures, not arrays of extracted values. This allows:

passing range slices through pipelines
keeping intermediate objects lightweight
avoiding large intermediate spillage
reducing recalculation costs for multi-slice operations

3.2 Lazy Slice Evaluation

Using {n1; n2; …} arrays in index parameters creates a vector of deferred slices. Functions downstream resolve these slices on demand and only for the specific iteration that needs them.

This is especially useful for:

sliding-window logic
multi-pass transformations
tree/graph-like iterative algorithms in Excel
dynamic partitioning of ranges
recursive constructions implemented with SCAN/REDUCE

Infinite Sign-In Redirect Loop on Power BI

IBAD_IMRAN — Fri, 28 Aug 2026 19:22:49 GMT

Hi Community, I am stuck in an infinite sign-in redirect loop while trying to log into Power BI (app.powerbi.com). It repeatedly redirects between the login page and authentication screen without loading the dashboard.

Steps I have tried so far:

Cleared browser cache and cookies.

Tried accessing via Incognito / Private mode.

Checked third-party cookie settings.

Could you please guide on how to resolve this authentication redirect issue or if there is any tenant-level setting blocking access?

Thanks!

Excel puzzle - can't type into cell, exhausted support steps, need a tech wizard !

LeeVGreenwood777 — Fri, 28 Aug 2026 17:08:41 GMT

Excel desktop app on Mac won't let me edit cells (Word is fine)

already tried a full uninstall/reinstall with support

MacBook Air, macOS Tahoma 26.2

- Microsoft 365 Premium subscription

- Excel for Mac, Version 16.111.1

Problem:

In the Excel desktop app I can navigate the sheet and select/highlight cells, but I cannot type into a cell or into the formula bar

Already tried with a Microsoft support agent:

1. Confirmed subscription is active

2. Removed the Office license from Keychain Access

3. Fully removed the Office apps, emptied the Trash.

4. Reinstalled Office from account.microsoft.com

5. Result: Excel still won't let me type in a cell or in the formula bar, even in a new book

6. "Allow editing directly in cells" enabled.

8. Confirmed the keyboard itself is fine: Cmd+C works inside Excel, types normally in TextEdit

9. Opened Excel in safe mode (held Shift while launching) and creating a new blank workbook — issue persisted.

Microsoft support agent confirmed this isn't a subscription/activation issue and isn't a general keyboard/OS issue, since Word, TextEdit, and Excel's own search box all accept input normally — the problem is specifically isolated to typing into a cell or the formula bar in Excel.

Any ideas on what else could be blocking keyboard input specifically in Excel's grid/formula bar (e.g. a stuck editing mode, add-in, or accessibility permission specific to Excel) would be ! VERY ! appreciated.

Help me solve this Excel Power Query editor issue

man77 — Wed, 26 Aug 2026 08:09:33 GMT

I've been facing this issue in the power query editor. Kindly help me in this. I've already done an online repair but it didn't solve the issue.

Shape distortion in excel older version and office 365 (At office vs home)

manupatt — Wed, 26 Aug 2026 06:52:30 GMT

Actually, if 3 rounds are in line, one change to oval. not other 2. Similarly distortion happens to rectangles and texts too

Excel Desktop Filter Checkboxes Not Visible – Windows 11 / Office Home & Student 2021

komatiramakanth — Wed, 26 Aug 2026 04:08:46 GMT

Excel Desktop Filter Checkboxes Not Visible – Windows 11 / Office Home & Student 2021

I am facing a persistent display/rendering issue in the Excel desktop application when using filters.

When I apply a filter to a column, the filter dropdown opens correctly and the values are displayed. The filter functionality itself also works. However, the checkboxes beside the individual values are not visible properly.

As shown in the attached screenshot, the values such as 11, 12, 22, and 34 are displayed in the filter list, but the checkbox controls beside them are either missing/not rendered correctly. Interestingly, the Select All checkbox area also appears abnormal.

System details

Operating System: Windows 11
Microsoft Office: Home & Student 2021
Application: Microsoft Excel Desktop
Office is fully updated with the latest available updates.
The same Excel file works correctly in Excel for the Web, where all filter checkboxes are displayed normally.

Troubleshooting already performed by Microsoft Support

Microsoft Support has already remotely checked the system and tried several troubleshooting steps, including:

Reinstalling Microsoft Office
Creating/modifying relevant Windows Registry entries
Creating system restore/checkpoints during troubleshooting
Creating and testing with a new Windows user profile
Checking and installing all available Office updates

Unfortunately, the issue still persists.

Since the problem does not occur in Excel for the Web, it appears to be specific to the Excel desktop application's UI/rendering on my Windows 11 system.

Has anyone experienced a similar issue with filter dropdown checkboxes not rendering or appearing invisible in Excel Desktop?

Could this be related to:

Excel hardware graphics acceleration/rendering
Windows display scaling or DPI settings
GPU/display drivers
Office 2021 UI rendering
Windows 11 accessibility/display settings
A known Excel Desktop bug

Any suggestions, known fixes, or confirmation of a similar issue would be appreciated.

Screenshot attached for reference.