Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
1,671 questions with Microsoft 365 and Office | Excel | For business | MacOS tags
1 answer
Unable to use Visio on MacBook and need alternative for org chart
Hi everyone, I’m currently using a MacBook (macOS 26.5.1) and I’m trying to work with a Visio (.vsdx) file that I created offline. I understand that Visio desktop is not supported on macOS, so I tried opening the file using Visio for the web via…
Microsoft 365 and Office | Excel | For business | MacOS
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 25%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGN%3C/text%3E%3C/svg%3E)
1 answer
Copilot in Excel for Mac Unable to Edit Files
Hi Microsoft Support Team, We are currently experiencing an issue with Copilot for Excel on Mac. After opening OneDrive and uploading Excel files to it, Copilot is unable to edit the excel files . Issue Details When trying to use Copilot in Excel, the…
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
asked 2026-06-15T08:52:58.07+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 69%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBJ%3C/text%3E%3C/svg%3E)
Biber Jin
0
Reputation points
commented 2026-06-19T00:12:31.28+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 9%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Michelle-N
17,775
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
Problem Sharing files and connecting to server
I cannot share files from excel or word or from documents I've downloaded. I get the message that the server cannot be connected. I use a Mac laptop
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
asked 2026-06-12T20:58:29.0333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 63%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Pat Cecchi
0
Reputation points
commented 2026-06-18T22:53:33.8633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 86%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKL%3C/text%3E%3C/svg%3E)
Kai-L
14,395
Reputation points Microsoft External Staff
Moderator
1 answer
Excel Data Loss After Office Update
Hi, A user updated Office 365 for Mac to 16.109.3 (26053122). After the update, an Excel file saved locally on Desktop lost many recent edits. Autosave and OneDrive back up were not enabled. Checked the AutoRecover folder…
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 94%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
2 answers
Copilot connection issues to Excel on Desktop
I am using a MacBook Pro and all systems are up to date including Excel. I keep getting a message from Copilot in Excel that it is having persistent internal issues connecting to excel. I am using the correct type of excel file and it is saved to…
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 35%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
1 answer
Cannot connect CoPilot to Excel, notified by CoPilot that Excel API is not responding to requests
I cannot get CoPilot in Excel to run prompts that it had been doing up to June 3. The error messages complain about lack of connectivity, but only once was I provided with anything specific: "I apologize, but I'm experiencing persistent technical…
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
asked 2026-06-09T20:29:20.0466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 15%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDF%3C/text%3E%3C/svg%3E)
Dave Finley
5
Reputation points
commented 2026-06-17T16:56:43.26+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 68%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHC%3C/text%3E%3C/svg%3E)
Hendrix-C
17,580
Reputation points Microsoft External Staff
Moderator
1 answer
How to access an online excel spreadsheet
Hi, I cant find an excel spreadsheet I created a few weeks ago. How can I go about finding it or which email address I logged into around that time to be able to have created it.
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
asked 2026-06-15T14:35:09.9966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 82%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIW%3C/text%3E%3C/svg%3E)
Imade Williams
0
Reputation points
commented 2026-06-16T20:33:25.42+00:00
Kai-L
14,395
Reputation points Microsoft External Staff
Moderator
1 answer
Why are "Add-Ins" not loading on M365 Suite tools, and only when signed into personal account
I've exhausted all options I can think of, and in desperate need of assistance. I have never done this before but figured I would give it a shot. I work at an MSP where we provide IT Support and the works to our clients. We manage an M365 tenant for…
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 61%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
2 answers
Pivot Table causing spill error on one machine but overwrite prompt on another (same Excel version)
I’m facing an issue with Pivot Table behavior in Excel that differs from my colleague’s machine, even though we are using the same version. Our application depends on the overwrite warning popup, but on my system, I get a spill error instead. Steps to…
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
asked 2026-03-30T04:17:33.5066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 37%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERV%3C/text%3E%3C/svg%3E)
Ritesh Virulkar
0
Reputation points
commented 2026-05-20T04:48:03.25+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 1%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Dora-T
14,370
Reputation points Microsoft External Staff
Moderator
2 answers
EXCEL OFFICE 365. FILE option missing next to HOME on ribbon
I AM GOING NUTS! I have for the past hour tried to do everything to get the FILE option showing to the left of HOME on the ribbon in Excel. (ON a MAC) I have tried ctrl/clicking (right click) on the ribbon. Nothing happens. I have tried…
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
asked 2026-05-07T18:28:23.1633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 93%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Paul Argyropoulos
0
Reputation points
commented 2026-05-07T19:32:01.8266667+00:00
Kai-L
14,395
Reputation points Microsoft External Staff
Moderator
1 answer
[Graph API Issue] Intermittent GenericFileOpenError causing missing data blocks when writing batched data to Excel workbooks
Our customers schedule automated data downloads that write batched data to Excel workbooks (OneDrive for Business / SharePoint) using the Microsoft Graph API. The API fails intermittently, resulting in missing blocks of data in the Excel sheet with…
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
asked 2026-04-21T12:17:02.98+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 28.000000000000004%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
Garima Chandna
0
Reputation points
commented 2026-05-04T10:11:02.19+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 19%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Jayden-P
23,245
Reputation points Microsoft External Staff
Moderator
1 answer
I need to use Unicode (UTF-8) encoding charset on Excel365 with Mac OS. How can I set that in Preferences?
I am using excel365 locally on Mac. I need to use Unicode (UTF-8) encoding to display character sets for Turkish properly. When I edit a new file on the my Mac the Turkish characters are displayed properly. But when I open an external css file the…
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
asked 2026-04-27T11:51:55.3866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 69%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sukru Alemdar
0
Reputation points
commented 2026-04-29T11:08:07.3233333+00:00
Michelle-N
17,775
Reputation points Microsoft External Staff
Moderator
1 answer
Stock quotes in Excel has been down all day
When will this be fixed? I have been checking every half hour, but it is still not working. The only message is that the Server is temporarily having problems.
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
asked 2026-01-02T19:10:49.9333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 65%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Chris D
30
Reputation points
commented 2026-04-28T17:38:36.8733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 11%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHN%3C/text%3E%3C/svg%3E)
Hans Noordam
0
Reputation points
3 answers
Clipboard Problem
If I copy a cell then delete the cell the clipboard is erased and the data from that cell is lost. Similarly, I can delete multiple cells and undo multiple times to restore the cell data, but if I delete a cell and then hit make a keystroke there is only…
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
asked 2026-04-22T20:56:40.0533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 89%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Clay Simchick
0
Reputation points
answered 2026-04-27T20:55:45.4133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 49%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Jay Tr
12,960
Reputation points Microsoft External Staff
Moderator
2 answers
how do i highlight a row with a data set that appears in one column
Using Excel for Mac Version 16.107 (26030819), I'm looking for several specific values in column K
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
asked 2026-04-24T17:40:01.0433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Landis, Michael
0
Reputation points
commented 2026-04-27T15:28:02+00:00
Hendrix-C
17,580
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
EXCEL for MAC v.16, Microsoft 365. How to populate cells in a Table based on the values entered into Entry cells using a reference table.
I want to populate several cells in a Table (Table B) based on the values entered into Entry cells. Table A , with 37 different options, will serve as a Reference for the values to be populated. More specifically: By entry of a value (0-36) into a…
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
asked 2026-04-26T19:24:16.5166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 24%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
McCaleb5635
20
Reputation points
accepted 2026-04-26T23:59:35.5766667+00:00
McCaleb5635
20
Reputation points
1 answer
On my Macbook, how do I update trusted add-in catalog in Excel
On my Macbook, how do I update trusted add-in catalog in Excel
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
asked 2026-04-21T17:50:00.8566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 81%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENP%3C/text%3E%3C/svg%3E)
No Pricing Calculator
0
Reputation points
commented 2026-04-22T22:38:37.58+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 69%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHV%3C/text%3E%3C/svg%3E)
Hin-V
15,490
Reputation points Microsoft External Staff
Moderator
2 answers
macOS sandbox restriction: ~/Library/Containers/com.microsoft.Excel not created or accessible on newer Macs (M4) – impact on Excel add-ins
We are encountering an issue with Excel sandbox container access on newer macOS devices (specifically Apple Silicon machines like M4). Our application integrates with Microsoft Excel and relies on the following path for certain…
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
asked 2026-04-21T05:40:06.8166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 31%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIL%3C/text%3E%3C/svg%3E)
Indraneel L
0
Reputation points
commented 2026-04-22T03:38:19.8466667+00:00
Dora-T
14,370
Reputation points Microsoft External Staff
Moderator
3 answers
Run-time error '1004': Method 'Name' of object 'Addln' failed
I am getting a notice when I open Microsoft Excel. Run-time error '1004': Method 'Name' of object 'Addln' failed. How to fix it.
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
asked 2026-04-19T11:16:03.4866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 85%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIA%3C/text%3E%3C/svg%3E)
Imran A. Bhutto
0
Reputation points
commented 2026-04-20T22:34:22.6166667+00:00
Hendrix-C
17,580
Reputation points Microsoft External Staff
Moderator
2 answers
Combining a Let and averageif formula.
Monthly we collate items bought for our manufacturing franchise to produce KPI stats. This formula works. =LET(items,$a$1:$a$300,qty,$c$1:$c$300,keys,Parms!$C$2:$C$3,SUM(SUMIFS(qty,items,keys))) where Parms lists the variables we search for, in this case…
Microsoft 365 and Office | Excel | For business | MacOS
Microsoft 365 and Office | Excel | For business | MacOS
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,671 questions
asked 2026-04-15T23:36:06.3633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 76%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Andre Hofer
85
Reputation points
answered 2026-04-17T07:29:21.63+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 3%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
IlirU
2,491
Reputation points
Volunteer Moderator