Content
Table transform in Excel
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…


Group values and send email based on excel data.
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…


Power Query Question
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!


Pivot Graph Series Color Changes for Previously Set Data Series
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…


Excel Restricted Access Workbook Preventing Autosave
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…


Update method 2016 MSO (16.0.5254.1001) 64-bit
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…


What qualifier can I use for vbcomponents, other than sheets.add
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…


How to get all the billing data for a subscription in Azure on to Excel
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…


How to Enable VBA Macros
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 the possible MODE for Provider=Microsoft.ACE.OLEDB.12.0
What are all the possibilities for MODE for Provider=Microsoft.ACE.OLEDB.12.0 and what do they mean ?


Microsoft should FIX - "Errors were detected while saving (filename)"
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).…


Embed Images with CDO mail - additional question
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…


frequent error when refreshing pivot table
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…


Why won't my SharePoint list export to excel?
Do I need to have some rule turned on for export to excel to work from my SharePoint list?


Excel "3D Map" feature error: 3D Maps encountered an error while contacting Microsoft Bing mapping services. Functionality may be limited. (Status Code: 4)
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…


Error message: Contact your admin to enable embed code creation
What is the issue with the prompt "Contact your admin to enable embed code creation" when publishing the WEB on Power BI?


Using a Function macro form another workbook
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…


Excel Vlookup for SharePoint exported Lists
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…


Opening excel from teams with macro that are blocked
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...


Report a problem with MS Team about unable to open .csv
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?

