Word
A family of Microsoft word processing software products for creating web, email, and print documents.
736 questions
2 answers
I cant redeem my Microsoft Office 2019 Home & Student code on my new pc
So I bought a pc a while back, and it can with Microsoft Office 2019 Home & Office preinstalled, but now I want to download it on my new Computer. I tried redeeming the code on https://setup.office.com/, but the following error came with it: Kehren…
Word
PowerPoint
PowerPoint
A family of Microsoft presentation graphics products that offer tools for creating presentations and adding graphic effects like multimedia objects and special effects with text.
245 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,058 questions
asked 2024-07-01T14:46:26.3133333+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
answered 2024-07-05T20:18:54.6033333+00:00
Charles Kenyon
2,781
Reputation points
0 answers
microsoft visio viewer was not able to complete the operation - vba in excel
I am using the Visio Viewer Active X control in excel. When I try using the following method I get the message "microsoft visio viewer was not able to complete the operation" Sheet1.ViewerSMG.Load…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,684 questions
Visio Management
Visio Management
Visio: A family of Microsoft products used to create diagrams and vector graphics.Management: The act or process of organizing, handling, directing or controlling something.
251 questions
asked 2024-07-04T16:02:04.78+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(294.40000000000003, 85%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
stewart graham
0
Reputation points
edited a comment 2024-07-05T19:25:05.9233333+00:00
Viorel
114.1K
Reputation points
1 answer
When I create a module in VBA and I'm typing a line of code, it just closes, any solutions?
I'm creating a simple registration system in Excel, I open Visual Basic normally, but when I click on "insert" and then "Module", after 10s Excel closes.
asked 2024-07-04T21:01:09.3766667+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, 94%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Nathanael Andrade
0
Reputation points
commented 2024-07-05T14:24:17.0233333+00:00
Nathanael Andrade
0
Reputation points
2 answers
Getting an error when export a sharepoint list as query in excel
When I tried to export for excel my sharepoint list, and I open the query on excel it shows the follow message as an error:: "There isn't enough memory to complete this action. Try using less data or closing other applications" I tried to…
![](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, 24%, 10%)' 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)
1 answer
Glitches in Excel formulas
02.07.24 Fd Wge Cost Bgt 24-25 - 10 (version 8 13.05.24.xml Hi, We have a problem with the attached spreadsheet. The details are as follows: Daily Spreadsheet : "Monday" Wages Q2985 "Minimum" formula for Mondays only works with…
asked 2024-07-04T10:29:18.0633333+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(230.39999999999998, 20%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Laurence Clerkin
0
Reputation points
commented 2024-07-05T02:06:04.7+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(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua-MFST
7,315
Reputation points Microsoft Vendor
0 answers
API unavailable for TableRow:delete
Hi, I have been trying to use delete row https://learn.microsoft.com/en-us/graph/api/tablerow-delete?view=graph-rest-1.0&tabs=http but I always get the following error: The API you are trying to use could not be found. It may be available in a newer…
![](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(208, 97%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
2 answers
"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."
One of the users receive this error. is this issue at our end or at microsofts ?
asked 2023-10-25T20:03:28.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(64, 5%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZA%3C/text%3E%3C/svg%3E)
zubaid ahmed
0
Reputation points
commented 2024-07-04T11:55:51.04+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, 6%, 31%)' 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)
gmuir
0
Reputation points
0 answers
How to fix missing authentication cookie in a shared Excel file
I was able to view a shared with me link to an Excel worksheet for a few weeks and now I get a Microsoft verify me window, I put in the code emailed to me and then it fails and says "authentication cookie could not be updated." I tried regular…
![](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, 11%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%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(227.2, 37%, 32%)' 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)
1 answer
My Copilot chatbot is picking data from Excel knowledge resource
My Copilot chatbot is not picking data from Excel knowledge resource. I have uploaded an excel sheet in the 'Add Knowledge' section. I try to ask questions based on the excel data, but it always says 'I’m sorry, I’m not sure how to help with that. Can…
asked 2024-07-04T05:26:19.7166667+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(32, 10%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBA%3C/text%3E%3C/svg%3E)
BANSAL, ASHISH
0
Reputation points
answered 2024-07-04T07:06:37.66+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(12.8, 11%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJZ%3C/text%3E%3C/svg%3E)
Jing Zhou
4,670
Reputation points Microsoft Vendor
1 answer
Why does DATEDIF give different results in Excel and SharePoint?
The following formula gives different results in an Excel worksheet and a SharePoint list: =DateDif([Date_1],[Date_2],"md") There are ten cases where Excel gives a higher number than Sharepoint, and two cases where SharePoint gives a higher…
asked 2024-07-02T11:15:45.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(185.6, 43%, 27%)' 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)
Remster
0
Reputation points
commented 2024-07-04T02:11:18.7866667+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, 33%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHX%3C/text%3E%3C/svg%3E)
Haoyan Xue_MSFT
21,826
Reputation points Microsoft Vendor
1 answer
how to get the PIVOTBY function working on my excel
how to get the PIVOTBY function working on my excel?
asked 2024-07-03T18:26:18.65+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, 57.00000000000001%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jason
0
Reputation points
answered 2024-07-04T01:55:54.84+00:00
Emi Zhang-MSFT
23,351
Reputation points Microsoft Vendor
3 answers
How can I fix the error "Method 'range of object'_Worksheet' failed
I have the following code. When I change a cell, it begins to work, but I get an error "Method 'range' of object'_Worksheet' failed," after it fills in the first cell Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,684 questions
asked 2023-08-07T19:39:46.04+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(297.6, 54%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Richardson, Brenda J (She/Her/Hers)
0
Reputation points
answered 2024-07-03T19:03:57.54+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(208, 30%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWK%3C/text%3E%3C/svg%3E)
Williams, Kim (US)
126
Reputation points
1 answer
One of the answers was accepted by the question author.
Looking for a formula to highlight an entire row when a date in column J is 60 or < days than current date in Excel
I need a formula for conditional formatting that will highlight a row when the date in column J is <60 days from current date. Any help would be appreciated!
asked 2024-07-02T17:28:16.51+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, 49%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Meagan Dally
20
Reputation points
commented 2024-07-03T13:03:41.9133333+00:00
Meagan Dally
20
Reputation points
1 answer
Linking data from an Excel file to a Visio file using SharePoint?
I am trying to use the 'Link Data' feature in Visio to link to an Excel spreadsheet located in SharePoint. Currently it is accessing the file through my OneDrive which means that when others with access to the SharePoint open the Visio file, the data…
![](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(262.40000000000003, 7.000000000000001%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
1 answer
Data from a csv file to excel, date is in MM/DD/YYYY format, region set as Australia
Newbie here so simple language please. Data was transferred as a csv file into excel file. I have subsequently entered more data. I have noticed the date of the imported data is in MM/DD/YYYY format even though settings, region, language and cell format…
asked 2024-06-18T06:28:41.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(198.4, 49%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBA%3C/text%3E%3C/svg%3E)
Body and Sole Podiatry
0
Reputation points
commented 2024-07-03T07:13:26.65+00:00
Jiajing Hua-MFST
7,315
Reputation points Microsoft Vendor
1 answer
Automate data entry on specific date every month
I have designed a table for my monthly income and expense entry. There are certain entry like home loan EMI needs to enter on specific date i.e. 5th of every month. now i wanted to make this entry on auto mode every month in my table. i tried few of…
asked 2024-06-24T19:37:45.63+00:00
Vishal Jhaveri
0
Reputation points
commented 2024-07-03T05:40:22.64+00:00
Jiajing Hua-MFST
7,315
Reputation points Microsoft Vendor
1 answer
split cells in excel
how to split individual cells?
asked 2024-06-25T12:59:44.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(179.20000000000002, 66%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mohammad Asif
0
Reputation points
commented 2024-07-03T05:32:37.1466667+00:00
Jiajing Hua-MFST
7,315
Reputation points Microsoft Vendor
0 answers
How to fix "an operation that uses the driver could noet be compleated. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Querry." whiel using Inventory Cube in Escel
Hello, We're trying to troubleshoot the error that is occurring for one of our user's when he tries to run Inventory Cube within Excel. We've already tried reinstalling Office, running Excel in safe mode, changed the settings in order to unblock DDE,…
asked 2024-07-02T12:56:05.92+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(89.60000000000001, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Suchecki, Jan
0
Reputation points
commented 2024-07-03T01:52:44.9766667+00:00
Emi Zhang-MSFT
23,351
Reputation points Microsoft Vendor
1 answer
Excel Differences between two worksheets but worksheets have dependent columns
I need to find a formula that supports the ability to highlight differences between two worksheets. Each worksheet has the same two columns. Those two columns are dependent of each other in order for the information to be correct. I need the formula to…
asked 2024-07-02T19:50:39.59+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(236.8, 93%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Samantha Huie
0
Reputation points
commented 2024-07-02T22:16:10.0766667+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, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Barry Schwarz
2,421
Reputation points
1 answer
How to fix the issue regarding the limit of 256 characters in data validation in excel
Hi, I am directly inputting values from code base on to the drop-down list using data validation, where facing issues while opening the excel file. Where have notice if the total characters of the list of dropdowns is within 256 characters, am able to…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,684 questions
asked 2024-07-01T07:44:04.9733333+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, 80%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Deepak Kumar Swain
0
Reputation points
edited an answer 2024-07-02T09:48:21.4+00:00
Viorel
114.1K
Reputation points