Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 questions
1,405 questions with Microsoft 365 and Office | Excel | For business | Other tags
1 answer
HI I HAVE MICROSOFT 2021EXCEL 365 , I AMTRYING TO USE FILTER FUNCTION BUT IT GIVE ME THIS #CALC
Microsoft 365 and Office | Excel | For business | Other
asked 2025-12-04T20:01:50.33+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(9.6, 39%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
ALAA2
0
Reputation points
edited the question 2025-12-04T21:31:25.8033333+00:00
Gérard Oomens
113.2K
Reputation points
Volunteer Moderator
2 answers
STOCKHISTORY function in Excel does not show all the tickers in Hong Kong Exchanges (XHKG)
STOCKHISTORY does not return some tickers result. For example, XHKG:3042 => No Good XHKG:3046 => NG XHKG:3476 =>NG However, some other work flawlessly: XHKG:5 => OK XHKG:2800 => OK XHKG:388 => OK Please fix that.
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 questions
asked 2025-11-27T03:51:13.76+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(83.2, 22%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Joshua Chung
1
Reputation point
commented 2025-11-28T05:24:42.0233333+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(124.80000000000001, 50%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDN%3C/text%3E%3C/svg%3E)
Darren-Ng
5,640
Reputation points Microsoft External Staff
Moderator
2 answers
how to unblock macros in excel, as i m not able to edit some cells because they show the file is protected
how to unblock macros in excel, as i m not able to edit some cells because they show the file is protected
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 questions
asked 2025-11-26T11:53:52.5233333+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(144, 18%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sanjana Kumari
0
Reputation points
commented 2025-11-27T13:40:27.9066667+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(25.6, 60%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Phoebe-N
6,650
Reputation points Microsoft External Staff
Moderator
2 answers
adding new tabs with the + sign
Morning, hope you can help. I have joined a new company for my job and in excel where we create pruchase orders and generate PDF's from it. The tabs at the bottom, i cannot create new ones. If i go into the order sheet, when pressing new +, nothing…
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 questions
asked 2025-11-06T10:58:58.4366667+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(6.4, 50%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sy Shaw | KHM
0
Reputation points
commented 2025-11-16T05:49:57.33+00:00
Darren-Ng
5,640
Reputation points Microsoft External Staff
Moderator
3 answers
How do I crate a drop down Calander in a column of cells for any date
I'm trying to create a drop down in a column of cells that will show a monthly Calander that I can click on a specific date
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 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(128, 35%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELJ%3C/text%3E%3C/svg%3E)
2 answers
Using a List of employees to open report
I would like to open a report based on the selection from a list of employees. Can this be done? IF so, please assist.
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 questions
asked 2023-04-02T03:15:22.6066667+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(166.4, 27%, 26%)' 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)
imodett
61
Reputation points
edited an answer 2025-11-06T11:14:46.5+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(64, 24%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
leo lawson
0
Reputation points
1 answer
Difficulties attaching emails (macros?) and difficulties sending emails without replying to a sender
Since downloading MS 0365 software, I have been encountering difficulties with attaching certain Excel documents to emails from a (freelance) work account. I suspect the system means that the attachment is somehow perceived as contacting a…
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 questions
asked 2025-10-22T14:52:52.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(252.8, 16%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Sue Devonshire
0
Reputation points
commented 2025-10-24T18:16:06.9566667+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
6,035
Reputation points Microsoft External Staff
Moderator
1 answer
Power Query - I need help
Deleting original question for security purposes since this is question had sensitive data in it
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 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(0, 73%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Image embedding displays correctly on the Excel desktop application, the online viewer such as Onedrive or Sharepoint has different rendering behavior, causing same images to appear on all sheets
Hi, I am facing issue with Image embedding using ExcelJS. When embedding images in a single Excel file from multiple source excel files, problems arise when the file is opened in Sharepoint or oneDrive site. While the same excel file with embedding…
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 questions
asked 2025-09-11T07:35:25.3533333+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(233.6, 86%, 32%)' 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)
Srinidhi Anand
20
Reputation points
recommended 2025-10-07T07:57:02.3466667+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(188.79999999999998, 40%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Alexandra Tanasescu
0
Reputation points Microsoft External Staff
Moderator
1 answer
Excel on sharepoint permission to use pivot table but not change data
Would like a user to be able to filter pivot tables in file but not change data. File is on SharePoint
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 questions
asked 2025-10-02T20:54:23.9666667+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(73.60000000000001, 67%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQC%3C/text%3E%3C/svg%3E)
Quinn Cushing
0
Reputation points
commented 2025-10-06T19:10:46.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(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
7,000
Reputation points Microsoft External Staff
Moderator
1 answer
I would like to request certificate of residence for 2024 & 2025
I would like to request a Certificate of Residence for the years 2024 and 2025.
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 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(281.6, 47%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFU%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(272, 12%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
4 answers
How can I correct the #calc error for this formula?
Hi. I am getting the #calc error with this formula. Can you help? Screenshot 2025-09-23 144838.png =LET(f,FILTER(A2:C39371,A2:A39371=F2),c,CHOOSECOLS(f,2),1/LOOKUP(2,1/FILTER(TAKE(f,,-1),c=TAKE(SORT(c,,-1),1))))
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 questions
asked 2025-09-23T18:49:38.6566667+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, 88%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Patricia Stephenson
0
Reputation points
answered 2025-09-29T22:41:51.1366667+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
8,005
Reputation points Microsoft External Staff
Moderator
2 answers
Macro setting has been disable but still blocked when open in SAP
Dear Microsoft, Our SAP users are facing error while opening Excel in SAP. We have already disabled the macro setting at the Excel but still this error is occurring. Please assist. Regards, Maizah
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 questions
asked 2025-08-19T09:01:51.44+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(259.20000000000005, 16%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Maizah binti Khairuddin
0
Reputation points
commented 2025-08-20T02:34:45.7766667+00:00
Maizah binti Khairuddin
0
Reputation points
2 answers
Is there a way to filter the rows used in a COUNTIF function?
Hi! I'm trying to make a tool to auto-review absence and sickness in the team, and I can't for the life of me figure out how to count absence totals the way I want to. I've made a (much) smaller fake sample to try and explain what I want to do: I need…
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 questions
asked 2025-07-28T14:08:28.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(166.4, 56.00000000000001%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
R0502
20
Reputation points
answered 2025-08-13T23:19:58.6533333+00:00
Ashish Mathur
100.8K
Reputation points
Volunteer Moderator
5 answers
Return latest price based on exact match of Product and latest date
I want to return the latest Price based on an exact match of product and the latest date. The latest price should be Apple = $1.00
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 questions
asked 2025-07-28T16:21:46.79+00:00
Patricia Stephenson
0
Reputation points
answered 2025-08-13T23:11:07.4433333+00:00
Ashish Mathur
100.8K
Reputation points
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
Is there a way to make a workbook link to an entire table in Excel Web?
Hi! Is there a way to link to a specific table in a different online workbook using workbook links? I've been testing the formula below on a duplicate of our current rota, to take our messy admin side of things to an easier view for the…
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 questions
1 answer
OFFSET not working with workbook links
Hi! I'm trying to use the below formula, but get a #VALUE error that I really don't understand: =OFFSET('https://Workbook Link/[Workbook.xlsx]August 25 Admin'!$A$1,SUM(ROW()-1),SUM(COLUMN()-1),1,1) I've wrapped the ROW and COLUMN formulas in the SUM…
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 questions
3 answers
Excel Sheet Protections Turning Off Automatically
We're seeing an ongoing issue where Excel is turning off sheet protection automatically and through no intentional action from the users. We have a workbook stored in sharepoint accessed by 4-5 users either with the desktop app or, more commonly, via…
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 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(128, 96%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
1 answer
Is there a way to remove the quotation marks when using a cell reference in a formula?
Hi! I'm hitting a bit of a snag with a COUNTIF formula when it comes to setting the criteria. I want to use the cell reference 'Grade Inclusions'!Q1 in this instance, but that cell contains a TEXTJOIN function as I have a couple different grades I want…
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 questions
1 answer
Automatically Remove Apostrophes/Spaces from Forms Responses in Excel – VBA or Automate Script?
Hi everyone, I’m trying to automatically remove apostrophes (') and extra spaces from Microsoft Forms responses in Excel. It should work: “When a new response is submitted” (Microsoft Forms → Excel Online). Sample Data (Problem): Need: Remove ' and…
Microsoft 365 and Office | Excel | For business | Other
Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
1,405 questions
asked 2025-05-16T19:32:50+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, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
asked 2025-07-21T21:12:00.6766667+00:00
Anonymous