Content
Prompt to enable Macro's isn't consistent Office 2019 - Excel
Hello, I was wondering if anyone would be able to provide some insight on why it seems the prompt to enable macro's on Excel behaves very inconsistently. Our CRM system gives files the 'Mark of the Web' so following the recent changes…


Office 365 Apps Functions Limited On A Mac
I have an Office 365 subscription, and have for several years. I use the apps in my business. My primary computer systems are Mac computers. For years the Office apps have worked just fine on my MAc computers, but now I am getting a warning message when…


Best courses to become certified in Excel and PowerPoint
I would like to become certified in excel, What is the best option in doin this? Thank you


number format in excel sheet
Hi Expert how to change datatype in pivot table in excel sheets . from text to numbers currently value is in text as it is in column section i,e. id value 1 23


Question about Dynamics Business Central & Excel
Hi- I am a beginner using Microsoft products and have been at my job 5 months. My boss gave me a new task which is to... using a an Excel master file we have which list every inventory item we have and the cost and pricing etc. All anyone know to do is…


Threaded comment support by Office professional version of Excel
Is threaded comment supported by Office professional Plus 2021 version of Excel? When I tried to edit the comments by it that are edited by Office Home and Business 2021 or Microsoft 365 enterprise version of Excel, every single comment shows an error…


ADF Copy Activity fail when loading Excel file which size is more than 40 MB
I have a requirement where I am using ADF copy activity processing large-size excel files ( includes more than 30 columns, file size around 80-10MBs ) which meets "Out of Memory" error intermittently. I cannot get the solution to this issue,…


Import data from Web using login details
How do I import data from Web in excel using login details. It does not allow me to enter my login credentials. If anyone could provide me with steps that would be highly appreciated. Thanks Pasang


how to wright a function in VBA to calculate total minutes worked in a specific hour.
How to wright a function in VBA to calculate total minutes worked in a specific hour. I need to calculate total time worked in each hour in a spreadsheet and i am open for any ideas. I not sure if a function is the best route to go. I like to…


How can I modify this pivot table to show the desired data?
I am creating a pivot table where the row is the reason code, the column the month/year, and the values Distinct Count of Production Number. There are moments where a production number is found in reason code 4 and 22 or in 5 and 26. Regardless, how can…


SUMIFs from the Employee Attendance Record Template
From the Employee Attendance Template I downloaded for Excel, I have the following cells in the Calendar View Sheet: The cell "Days on Leave" show the following formula: =SUMIFS(LeaveTracker[Days],LeaveTracker[Employee…


office 365 - outlook now opening excel attachments as read only
we have office 365, and suddenly today, I am seeing lots of people complaining that when they receive an excel spreadsheet via email, it is always opening in Read Only mode. I have tried in Excel going to Trust Center and unchecking everything under…


How to fix excel student account credential?
Hi Unfortunately, I just disabled my student credential for excel. From managing device options I disabled it. Please help me with this. How can I fix this issue?


Power Pivot doesn't connect all tables
Hi, I cant get my tables to connect in power pivot. I have SQL and ODBC databases loaded in pv and connected them all to make some pivot tables. Everything works accept adding a relation with the ODBC table. I want this to connect to a column but it…


Excel macros not working with the two recipients, all three users sharing utilizing OneDrive and Microsoft 365..?
Excel macros not working with the two recipients, all three users sharing utilizing OneDrive and Microsoft 365… I share several Excel files with two other individuals through OneDrive utilizing Office 365. Myself and the other two individuals use…


How to send only one email using Power Automate based on a condition in different rows in Sharepoint Excel?
I am trying to send just one email to a particular user in Power Automate, where the program runs through all the rows in an Excel file, and based on a condition, adds the particular rows to a table, which it then sends to the user altogether. So far, I…


Can't interact with Excel because of hidden dialog box.
Hidden dialog box keeps Excel from operating properly. I've tried alt-tabbing the dialog does not show up. When I try to shut Excel down using the task manager since close it normaly I get a dialog box stating "You cannot close Microsft Exel…


Have Recon with only 2 columns but might have several rows on other to match, how can I find Matches?
Have a general Ledger account debit / credit but sometimes/most it several credits to match one debit, i have been doing by adding subtracting and takes a long long time. Plus they don't really have a unique name that would match the debit to credits,…


How do I change the default font for notes in Excel?
The default font for a New Note in Excel is 'Bold' and I want to set the default to 'Regular'.


Excel solvertable error
Every time I am running solvertable in Excel, I got a message: Error number 13 Type mismatch Does anyone knows how to fix it?

