Excel Management

Can’t log into my Dayforce account

When I try to log into my Ceridian Dayforce account I can’t log in.

Excel AddIn doesn't work any more - used to worked properly.

I have made a C# VSTO Excel AddIn code(several thousands lines) that have been worked perfectly for years. I'm with Office2013(32bit), VisualStudio2017 and Windows10. ... This problem started with Windows update "KB5050188", I guess. The AddIn…

Conditional formatting based on time since date in Excel.

I have a table where I keep track of applicants to our organisation. I have a column dedicated to when I first contact the applicant requesting documentation. I would like to format these cells to alert me when: It has been two weeks from initial…

Long delay for second Excel worksheet to open over network

Small company network with 1GB Ethernet and i5/i7 machines, all updated and running fine. All Win 10, locally installed Office 2021, 16BG RAM. If any of the users has an Excel workbook open and opens a second one from the local company storage (very fast…

I have a problem with macros enable excel when it comes to generating an uploaded file which is usually zipped it gives keep give a pop up that the modifications are not saved, upload file not generated and cannot access a specific sheet in the workbook,

How to count only the Chinese characters in an excel cell?

I'm new to excel and analyze a huge set of data. I need to count the Chinese characters only. The LEN formula counts all characters and I cannot figure out how to make it only count the Chinese characters! Please help!!!

Megastat is installed and it shows in the add ins box, but it is not functional when I open excel.

Megastat is installed, and it shows in the add-ins box, but it is not functional when I open Excel. It is ticked and all in the add-ins. I also checked that it is not blocked via the Megastat file properties. Also that the macros are enabled. When I…

excel 2021 to install on wi11---how to do

can I still install a personal copy of excel 2021 on win 11 and if so where to obtain iso for such

Create excel formula where 2 cells in one sheet (same row) match another - to pull a third cell value

I have 2 cells on my main worksheet tab representing a name. E4 is a last name. F4 is the first name. On another tab, called Form2, G4 is a last name, H4 is a first name. M4 in this tab has a date I want to pull (on the same row). But to pull this date,…

User unable to see the Office Store in Excel (we have it enabled).

User has O365, latest update (and a fresh Online Repair). E3 license. I have a user that when in Excel has no access to the Office Store. They go to Insert->Get Add-ins only has a tab for Admin Managed. I get all 3 with the same licensing. Below…

vlookup formula

I have two Excel sheets. In Sheet1, I have data in columns A, B, C, and D. Column D contains usernames in each row — some rows have a single username (e.g., user1), while others have multiple usernames separated by semicolons (e.g., user1; user2;), some…

Can someone create a formula to work out this equation for me please?

Hi I'm struggling to work out the following, please can someone help with the formula? I apologise in advance but I've had to hide the nature of what I need the formula for. I have a total number of "sweets" that need to be divided equally by…

How to fix Excel that will not allow formatting?

My excel file will not allow me to formatting any cells. All cells are acting like text and will not allow any monetary formatting, i.e. accounting or currency formatting.

Pasting Outlook 365 message headers to Excel as a list?

is there any method to export Outlook 365 message headers to Excel as a list? When I paste into excel, everything (including From, Subject, Date) is in one cell but it used to paste into different columns

Excel run-time error '13' type mismatch

I have downloaded an Add-In called FRED. When I try to "Get FRED Data it gives me this error Can you kindly assist me please?

Excel installs, but does not activate. If I go to manually install the key I get the error: "This product key is for the volume-licenses version of Microsoft Excel LTSC, which isn't currently installed. To use this product key contact you administrator"

Excel installs, but does not activate. If I go to manually install the key I get the error: "This product key is for the volume-licenses version of Microsoft Excel LTSC, which isn't currently installed. To use this product key contact you…

how to fix error message, sorry, we couldn't find C:\windows\System32\file name.xlsm. is it possible it was removed, renamed or deleted

i have an excel saved on the C:\windows\System32\ but when i try to open it brings the error message, is it possible it was removed, renamed or deleted. i also attached the error. i need support on how to fix this issue. thanks for all the support.

Office Script Timeout(s)

Hello, I have an excel office script that is running via PowerAutomate. The trigger for this is when a new email arrives and it loops through a number of conditions to pull out the respective document from the email, filter items from SharePoint to…

Getting 'OLE Automation error in Workbooks.Open: ObjectDoMethod' with MS Excel 2021 when we are creating excel using PeopleSoft

Hi, We are creating .xlsx file using PeopleSoft application engine (8.61.06) and MS Excel 2021 and we are getting OLE error randomly on regular basis. Same code is working file with MS Excel 2016 but with MS Excel 2021 we are getting OLE error. Below…

How to add VBA to a recently installed Excel on Windows 11.

Background: I recently bought a new machine with Windows 11. I moved most of my files from my old Windows 10 machine, including many Excel files. On my new machine, I paid for and installed Excel. Just Excel. I have no need for other MS Office products.…