This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello, I have raw data that are extracted in complex design, so I need to transfer these data from below: to below design: There are thousands of Customers IDs and thousands of Parts and Parts type, each part has 2 subtypes, so subtypes need to be…
Hello, I have the following Powershell script and I need a bit of help. The script takes the data from a .csv document and sends email to users that are the owners of each group. [powershell] # Function to create report email function…
I appended 31 sheets into a master using power query. Now I need to add the current rate percentage from current month towards their goals which is on a separate sheet. I started doing it manually but I do need it to be dynamic. Help please!
I have a Pivot Chart that shows Red/Yellow/Green metrics. I have set the series colors as appropriate for each series. On the occasion that data conditions result in the absence of one of the series...(for instance there are no Red items), this series…
Hi All, We are trying to restrict certain people from editing a file in excel while others can edit. When we use the 'restrict access' for certain individuals it removes the ability for the document to autosave. Is there any workaround for this? We…
Hello, I used excel version (16.0.4266.1001) 64-bit. I should update the current version as (16.0.5254.1001) - KB5002033. So, I installed KB5002033 then apply this file but it doesn't work. I mean still 16.0.4266.1001 Could you let me know the method of…
I am trying to add VBA source code to an EXISTING Excel worksheet. I have an example intended to create a NEW worksheet. Sample: Dim NewSheet as Worksheet Set NewSheet = Sheets.Add ... With…
I want to get All the billing data for one of my Azure subscriptions, and download that data as a excel file. I know that I can go to "Cost Management + Billing" and download all of cost and billing data, from there. But I cant seem to find…
Hi, Good day! I'm trying to use my VBA Macros applications, but I'm having this error message. Please help me resolve this. It's really a pleasure you would help me with this ASAP. Thank you so much!
What are all the possibilities for MODE for Provider=Microsoft.ACE.OLEDB.12.0 and what do they mean ?
Microsoft must FIX this decade long bug with appears out of nowhere and has ruined a lot of months of work of my life. Please fix the below error message. It is even appearing in latest Office 2019. "Errors were detected while saving (filename).…
Hi, I have seen David JunFeng's solution to embedding inline images at https://social.msdn.microsoft.com/Forums/en-US/f8c701b7-fbef-4a1f-9549-2fd16191dd20/embed-images-with-cdo-mail-in-excel?forum=exceldev The solution is for embedding inline images…
When refreshing a Pivot table that is created from another worksheet, I get: An unexpected error occurred (file'pcminorobjcoll.inl', line 109, function 'PCMinorObjectCollection[class PCProperty.class NameHashSupport]::SetNameAndUpdateCollection') This…
Do I need to have some rule turned on for export to excel to work from my SharePoint list?
Hello, I am running into an issue with Excel application where I am no longer able to use the "3D Map" feature. I used to use the search bar to load the feature but now when i do that i am faced with the following error: 3D Maps…
What is the issue with the prompt "Contact your admin to enable embed code creation" when publishing the WEB on Power BI?
I have project with multiple workbooks. To simplify macro management, I created a workbook with a single empty worksheet where I store all my macros. When this workbook is open, I can execute any of the Sub macros while working in another active…
Hi I have exported a number of SharePoint Lists to an excel spreadsheet, but I can not Vlookup to this data, does anyone know a work around. The files that are exported from SharePoint to excel are Query, so I don't think hold any data. I want to be able…
Hi! I'm opening an Excel file from a teams location. The excel contains macro's that are disabled when opening the excel. How to enable them? in the Trust center the macro's are enabled. But they are not...
How are the two versions different. Why can't office 2013 open .csv files? Open the .csv file on Microsoft Office std 2019 How to fix that?