Pasting & Linking in Word
I am currently trying to paste and link into Word from Excel. I am choosing to keep source formatting, but every time I paste, there are extra spaces in some of the cells with numbers. I have too many tables to paste over to delete all the extra spaces.…
clarify the complex date function
hi, i cannot make sense of this function, could you please clarify it to me: =IF(OR(MONTH(Input!$B$7)<3,MONTH(Input!$B$7)>9),DATE(YEAR(Input!$B$7)+(MONTH(Input!$B$7)>3),2,28),DATE(YEAR(Input!$B$7)+(MONTH(Input!$B$7)>9),9,30)) especially:…
Workbook.refreshAllDataConnections() is not supported in Power Automate.
Dear all, I have an excel sheet with an active connection which I am able to refresh to get the newest data. Now I've got another PowerAutomate Flow which is working fine with a script inside this Sheet to send me via Teams numbers which I want to be…
Data from a csv file to excel, date is in MM/DD/YYYY format, region set as Australia
Newbie here so simple language please. Data was transferred as a csv file into excel file. I have subsequently entered more data. I have noticed the date of the imported data is in MM/DD/YYYY format even though settings, region, language and cell format…
"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."
One of the users receive this error. is this issue at our end or at microsofts ?
Glitches in Excel formulas
02.07.24 Fd Wge Cost Bgt 24-25 - 10 (version 8 13.05.24.xml Hi, We have a problem with the attached spreadsheet. The details are as follows: Daily Spreadsheet : "Monday" Wages Q2985 "Minimum" formula for Mondays only works with…
Can I retain formula results if background data changes?
To Note I tried like 30 times to post this in the Excel Forums and keep getting some random error. I have a workbook with lets say 4 sheets. A-Coversheet B-Requirements Tracker C-Services D-Software Sheets A, C, and D have rows…
Python Function limit chars?
I was super excited to see Python was being supported in MS Excel. I have been waiting for this functionality for a very long time. I was pretty sad to see the limitation of only 8,415 characters per python script. Is there any way to increase this? I…
Help with "DataPivotHierarchy setSummarizeBy: The argument is invalid or missing or has an incorrect format." error
I have an excel script which used to run with no problems. Suddenly I'am getting an error when trying to set a column to summarise by average in a pivot table. I get the following error: DataPivotHierarchy setSummarizeBy: The argument is invalid or…
Why does DATEDIF give different results in Excel and SharePoint?
The following formula gives different results in an Excel worksheet and a SharePoint list: =DateDif([Date_1],[Date_2],"md") There are ten cases where Excel gives a higher number than Sharepoint, and two cases where SharePoint gives a higher…
Conditional formatting for a column based on the contents of another column
I am trying to format font and/or background for the cells in one column based on the content of the associated cell in another column. I can get it to work if I do it cell by cell but have no desire to set of the conditions individually for each cell. …
why Excel VBA modules are not getting saved?
Hello All, I am working on development of a project specific excel tool and I am stuck on one issue. I am facing an issue in saving the modules which I create in Visual Basics Window. The modules gets discarded every time I close the excel and reopen…
I need a simple and elegant solution to export a detailed audit of all changes to an Excel Online file.
What I'm looking for is a report that shows the same format as the legacy "Track Changes" function, but in a modern environment. I believe the best way would be to aggregate all of the changes that are listed by the "track changes"…
New Excel workbooks (created in SharePoint library) not launching in app - .xlsx "extension is not valid"
Hi there, Having a recent issue in some SharePoint sites - in Document Libraries, using the (default) New > Excel Workbook action gives the error when launching the app: "Excel cannot open the file 'Book.xlsx' because the file format or file…
How do I fix microsoft office error message "The operating system is not presently configured to run this application" I'm getting it for Excel and Outlook
Problem started today and neither Outlook nor Excel will open up.
dynamic add label to userform and click event
I want to dynamically add multiple labels to a userform and then capture the click event to run a macro based on the name of the label. I figured out how to add the labels but not the click event. Thank you in advance. :-)
microsoft visio viewer was not able to complete the operation - vba in excel
I am using the Visio Viewer Active X control in excel. When I try using the following method I get the message "microsoft visio viewer was not able to complete the operation" Sheet1.ViewerSMG.Load…
Vertical lines for scrollbar visible in desktop add-in when add-in section is resized
When i resize the add-in section in my excel desktop app these vertical lines are visible where the previous position of scrollbar was present. It works fine for the online excel spreadsheet issue only occurs in desktop application. I have tried clearing…
Why does excel report corrupted data on opening when linked to a google sheet
I am connecting an Excel workbook to a Google sheets document. I am pulling in data from both tabs in the Google Sheet to 2 tabs in Excel. The sheets shares the data to the web in excel format. The excel receives that data using power query. All the…