convert excel column headers as row headers in azure data factory
need to convert below example input from excel source - id qn1 qn2 qn3 ................ max q50 1 qr1 qr2 qr3 ................max qr50 2 qr1 qr2 qr3 ................max qr50 desired output - id qn qr 1 qn1 qr1 1 qn2 qr2 1 qn3 qr3 . . 1 qn50…
Errors were detected while saving excel file how I should save it
Errors were detected while saving excel sheet how I should save it.
How to fix keyboard issue in laptop in typing right to left and left to right.
If you're experiencing issues with your laptop keyboard where the typing direction switches between right-to-left (RTL) and left-to-right (LTR), here are some steps you can follow to fix it: Check Keyboard Shortcuts: Sometimes, the typing direction can…
Need help with Sync Outlook Calendar into Excel Spreadsheet
I need to figure out a way to Sync an Outlook Calendar into Excel spreadsheet without going back to the spreadsheet each time I add an event on the Calendar. Was watching video's yesterday but the concept of using codes went over my head just a little. …
Enable/Disable Drop Down List according to another value
I need to create a drop down menu, that only appears when a certain value in cell A2 is chosen (from another data validation list), but that it is disabled and blocks the cell (grey out and not possible to type anything) when the value in cell A2 changes…
Why does Excel freeze when copying large ranges and how can I fix it?
When attempting to copy a large range, Excel freezes and gradually consumes all available memory (16 GB) over a ten minute period. This issue occurs even in safe mode and repairing Office 365 has not helped. However, when running Excel as administrator,…
Run script on multiple users (using Excel table)
Hello everyone, im trying to build a PowerShell script that runs a command multiple times but with different URLs, but i cant quite understand how to build it. The point is to remove a user from the Share Point sites listed in the column D. So lets say…
Power query not loading numbers
Hello Every one, I use a query made out of excel files stored in a folder. On a regular basis, I add an excel file in the folder and refresh the query. Since the update of the 30th of May, when I refresh the query, every columns are loaded and added to…
Copilot for Excel
HI all. I just got copilot, so I am still learning how to make it work for me. I was excited about its use in Excel, but it doesn't appear to be ready for prime time. I have a sheet open and when I click copilot, it comes up in the right pane and…
Is Power Query Refresh Broken?
I'm experiencing an issue with Power Query refresh in Excel. I'm using Excel Microsoft Office Home and Business 2016 and the issue started after the May 30th, 2024 update. Here's a detailed description of the problem: I upload data from various sources…
I want to use a unified "UserForm" or any other Screen-Drop to address messages to the excel sheet user whenever there is an error instead of MsgBos.
While the user is using my excel sheet, instead of using MsgBox function, I want to use sort of a standard form with variable messages ; for example: if I can Call a procedure with ms1 & ms2 as message lines, and this procedure will pop-out including…
How can I force the 'Access Web content' user authentication dialogue box to pop up using VBA?
I have some Power Queries in my Excel file that pull data from other Excel files stored on a SharePoint site. When a new user tries to manually refresh those queries using the "Refresh All" button on the ribbon (Data / Queries &…
publishing PDF from excel should not opening automatically in desktop pdf adobe .it is happening in both Win 10 and Win 11
I'd like to explain that if we export the PDF from Excel, while publishing, the PDF it will be opened using the browser built-in PDF add-in instead of desktop Adobe app. If the PDF stored locally on the computer, it will find the Adobe reader app…
Erro ao executar um suplemento desenvolvido em VBA
A aplicação em VBA que fiz para automatizar os meus processos rodava até no dia 24 de agosto de 2023, e após esta data passou a aparecer o seguinte erro. Erro em tempo de execução '-2147417848 (80010108)' O objeto chamado foi desconectado de seus…
Excel connect to SQL Server using a different windows user name
hello, I am trying to connect to SQL Server in MS Excel using a different windows user credential other than current logged on windows user ID. using SQL Server database user name is not an option for me. Is there any function that can impersonate in…
When using Active X controls, a message that the object cannot be inserted appears.
When using Active X controls, a message that the object cannot be inserted appears. not available I would like to ask for your help. Thank you!
Excel file having links with different excel files opens with long delay
Hi some of our finance users are working on Excel sheet. they have one consolidated file which has link to almost 15 other excel files to fetch the data. it was working fine a couple of day ago but suddenly it is taking more than 20 minutes to open. Need…
Migrating Excel Files from On Prem to SharePoint while retaining links
We are currently planning a migration of active files from our on prem servers to SharePoint. We copied over a folder which has Excel workbooks with links to other workbooks. It appears the links do not work when opened from SharePoint. We have hundreds,…
How to renew Microsoft 365 Developer licence
I had subscribed to the Microsoft 365 Developer Program, but my subscription has expired and was not renewed. I am seeking assistance to resubscribe to the program
How to include numbers with hyphens in Subtotal function
I am currently using a =SUBTOTAL formula to count a column of date but am having some issues. For example, I have 30 cells in this column that all include various numbers, but they also include numbers with hyphens— ex. 20-22, 106-107 etc. when i run…