Recent Discussions
Using the Secret Management PowerShell Module with Azure Key Vault and Azure Automation
If you can't use managed identities, credential resources are a way to manage username and password credentials for Azure Automation runbooks. The Secret Management module is an alternative, and it’s a good option to manage credentials that are shared between interactive scripts and automation runbooks. This article describes how to use the Secret Management PowerShell module to fetch credentials stored in Azure Key Vault for use in an automation runbook. https://office365itpros.com/2025/10/16/secret-management-azure-automation/
VBA Data Import
Looking for VBA code to parse a list. The list is an extract of a music playlist which retains the Line 1 "name of song", skips the second line which is a repeat of Line 1. Line 3: Retains Artist name Line 4: Retains Album Name Line 5: Time of song - Will probably have to manually move or delete these manually The list is one of my Playlist from Amazon Music Prime. Thank you. Song Artist Album Time Whisper Whisper Marion Meadows Whisper 4:16 Just Doing Me Just Doing Me Marion Meadows Just Doing Me 2:54 Midnight Bolero Midnight Bolero Armik Amor De Guitarra 4:52 Every Kinda People Every Kinda People Architects of Sound
Group objects
Hi, I am a longtime user of Word. I have just transferred to a new and stronger laptop; however, when trying to group more than 5 items Word stops responding and sometimes crashes. I disabled all add-ons, hoping it would help. Any ideas? I usually insert the figure in a table and just group the callouts and text boxes with arrows.
Not including all columns when consolidating multiple Excel onto one tab?
Hello - I am running the following VBA code to write all rows/columns from multiple worksheets (in the same workbook) onto a 'consolidated' worksheet in that same workbook. My columns on all worksheets are the same and go out to Column 'BT'. My script runs fine, but is only writing out to Column 'BN' in my 'Consolidated' worksheet. Why is it cutting off Columns 'BM' thru 'BT'? Here is the VBA code I'm running: Sub ConsolidateVisibleSheets() Dim ws As Worksheet Dim destSheet As Worksheet Dim lastRow As Long, destLastRow As Long Dim copyRange As Range ' Create or activate the destination sheet On Error Resume Next Set destSheet = ThisWorkbook.Sheets("Consolidated") If destSheet Is Nothing Then Set destSheet = ThisWorkbook.Sheets.Add destSheet.Name = "Consolidated" End If On Error GoTo 0 destSheet.Cells.Clear ' Clear existing data on the destination sheet ' Loop through all sheets in the workbook For Each ws In ThisWorkbook.Sheets ' Skip hidden sheets and the destination sheet If ws.Visible = xlSheetVisible And ws.Name <> destSheet.Name Then ' Find the last row of data in the current sheet lastRow = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row ' Define the range to copy Set copyRange = ws.Range("A1", ws.Cells(lastRow, ws.Columns.Count).End(xlToLeft)) ' Find the last row in the destination sheet destLastRow = destSheet.Cells(destSheet.Rows.Count, 1).End(xlUp).Row + 1 ' Copy and paste with formatting copyRange.Copy destSheet.Cells(destLastRow, 1).PasteSpecial Paste:=xlPasteAllUsingSourceTheme End If Next ws ' Clean up Application.CutCopyMode = False MsgBox "Data consolidated successfully!", vbInformation End Sub Any help is greatly appreciated!Seamless Microsoft 365 Migration with Apps4Rent
Migrating to Microsoft 365 can be challenging without proper planning. From mailbox mapping to DNS updates, every step needs precision to avoid data loss or downtime. Partnering with experts like Apps4Rent can make the transition smooth and secure. Their specialists handle email, contacts, and calendar migrations with minimal disruption while ensuring compliance and data integrity. Whether moving from on-premises Exchange, Google Workspace, or another provider, Apps4Rent offers end-to-end migration support, and proven experience as a Microsoft Cloud Solution Provider. Businesses of all sizes can benefit from their structured approach, faster cutovers, and post-migration support. For anyone planning a shift to Microsoft 365, Apps4Rent is a trusted partner worth considering.Opening CSV file with UT8-encoding (65001) as default for csv files.
Hello, I am trying to open a csv file, that contains Arabic characters. In most cases, it will render the Arabic Character as unreadable characters (as shown in the image below). Those scenarios, include opening the file by double clicking, saving it again as CSV with UTF-8, or converting it to XLSX, all of which result in the same thing as the first image. The only I found to actually make it render them correctly by following this: https://support.microsoft.com/en-gb/office/opening-csv-utf-8-files-correctly-in-excel-8a935af5-3416-4edd-ba7e-3dfd2bc4a032 Which does allow me to select utf-8 encoding. Other CSV viewers don't have that issue. It would be convenient to have away to make this behavior the default. In my organization we have thousands of employees, and the fact they have to open Excel, go to the Data section, select import CSV, select the encoding, then click importing for every single CSV file we have is very annoying, we deal with thousands of files per month. The second Image is for another file: Here is the file in case anyone want to try to open it. Please note we need to support as old as Excel 2016 for any solutions. The CSV files are generated from Power Automate Flows, and we would really like to avoid any sort of conversion between the formats online (Though I don't mind if I can embed let's say, a character or so at the end of the file to make Excel open it correctly) as our experience has been very slow for anything Excel related in Power Automate (if for example we use Excel to generate the files instead of CSV, it would take around 3 hours for each file at least, compared to 5 minutes in CSV). Best, Ali A.
The My Sign-Ins Portal, Applications, and Conditional Access
A recent change has exposed the applications used by the My Sign-ins portal for use in conditional access policies. This article discusses the app-centric nature of Microsoft 365 and Entra ID and why it’s important that the newly-revealed set of applications are available for conditional access processing, just in case the Entra ID agents planned by Microsoft can’t optimize your policies. https://office365itpros.com/2025/10/15/my-sign-ins-portal/
Automate the function
Hi, I have a few thousand records of Course with ANZSIC allocation proportion. Is it possible to create an excel function to pick up the highest values within the same course whose difference of proportion with the next highest is within 0.1 and highlight it out? In this case, the first 3 records will be highlighted. Attached with an example for reference. coursecode coursename ANZSICDivisionDesc ANZSICDivisionCode ANZSICConcordanceProportion ABC123 Certificate III in Meat Processing (Food Services) Manufacturing C 0.45 ABC123 Certificate III in Meat Processing (Food Services) Retail Trade G 0.45 ABC123 Certificate III in Meat Processing (Food Services) Wholesale Trade F 0.1 BCD123 Certificate III in Meat Safety Inspection Manufacturing C 0.65 BCD123 Certificate III in Meat Safety Inspection Public Administration and Safety O 0.35 Regards EPOutlook (New) redicts to Microsoft Edge to access emails
After the recent 365 apps, a few users in our organization are experiencing an issue with accessing emails on the Microsoft Outlook (New). When we click on the Outook(New) icon and it opens and redirects to Edge window to access emails. I tried several troubleshooting steps to resolve this issue and submitted a case with Microsoft Support but not helpful so far. Anyone else experiencing the same problem ? Any suggestions or fix will be greatly appreciated. ThanksExcel desktop application crashes when trying to share or copy link
For the last couple of weeks when I've attempted to share an Excel file from the desktop app (multiple different files) the application crashed and closes out. The file are all saved to my personal OneDrive. It only seems to affect the files from my SharePoint, and only when trying to share through the desktop app. I can open it on the web version and share. I tried sharing a file that was opened through a SharePoint site and it seemed to work.Conditional Formatting
Hello, I am developing a conditional formatting rule that allows me to enter a specific text value, and if it matches the content of another cell, that cell will be highlighted in green. However, instead of highlighting only the matching cell, the entire selected range is being highlighted each time I enter a text value.
Countif/Countifs
I'm trying to do a standard countifs formula for several columns of information. Each column is using the same criteria but has different ranges. I'm trying to make an equation that will be easy to drag so I do not have to rewrite the range each time. Does anyone know how to do this? I have cells with the prewritten ranges I'll want to use. I can give more information if that helps people understand.Outlook for Mac - Upload and Share is not working as access "Recipients of this message" is missing
New Outlook for Mac has since some versions back gotten the feature where the user can upload a file and share it to the recipients of the e-mail. The file will be per default be uploaded to DOWNLOAD folder in OneDrive. Now this is not working on Outlook for Mac as the whole access permission Recipients of this message" is missing. On Windows and Outlook on Web, this is available, but not for New Outlook for Mac. It seems that this feature is not yet fully developed on Outlook for Mac. Any others that see the same and can confirm?
Word document printing issue
I am unable to print certain pages in a long, highly formatted Word document while other pages print fine. I am not getting any error messages, just nothing showing up in the print queu. I tried to copy the content into a blank Word worksheet but it doesn't fix the issue. I've spoken to both Level 1 and Level 2 technicians at MS and the best suggestions they can offer is to paste the entire document into a new file with basic text format and then reformat everything from scratch. In addition to being a very cumbersome workaround, there is no guarantee that the file won't print again after doing that. Plus, this "solution" doesn't address the underlying issue if/when this occurs again with a different file. Anybody have similar issues and/or suggestions?
Recent Blogs
- 3 MIN READTo support admins in the evolving AI landscape, we’ve introduced a range of new tools and policies for SharePoint admins.Oct 15, 2025
- Support for Office 2016 and Office 2019 ends today—start your migration to Microsoft 365 today.Oct 14, 2025
