excel
44934 TopicsCombinar correspondencia ahora que han desaparecido los DDE con resultados con solo dos decimales
Buenos días: antes combinaba correspondencia de un word con un excell, para hacer mis facturas mensuales con DDE, pero ahora esa opción ha desaparecido y cuando combino me salen muchísimos decimales. He aplicado el formato directamente en Word modificando el campo de fusión con un cambio de formato numérico (por ejemplo, \# "#,##0.00" para forzar dos decimales), pero sigue sin hacérmelo... alguna idea para poder fijar solamente dos decimales en el excell para que los resultados de la combinación en word den solo 2 decimales?35Views0likes1CommentPasting formatted tables from Excel into other software - issues
I am copying and pasting a large table, with lots of cells merged into, headers for combined rows and colums, with lots of coloured and formatted cells. When it is pasted into Word or Excel, the first 20-30 rows are OK, but then after a while, mid-row, the colour formatting (but not the cell text contents) becomes displaced a two cells to the right. The colouring then corrects itself further down the table, but then drifts in and out of alignment. I think it may be an issue with the merged cells, particularly in the case where if they weren't merged then the content of the cell is wider than the cell, so requires wrapping - but this does not appear to be consistently the issue. I have tried unmerging everything and allowing columns to autofit to full width, but that does not resolve... it had been fine until around March 2026 - was there an update around then? Any suggestions welcome.40Views0likes1CommentClosing VBA module is crashing excel
If I open a macro enabled workbook, go to developer>visual basic and try closing any VBA module windows, excel closes. If I then start excel, open a blank workbook, go to developer> visual basics and insert several blank modules, and then close one, excel closes. If I reboot my PC, open a blank workbook, go to visual basic and insert modules, now I can close them ok. But once I open an existing macro enabled workbook the problem starts over again. Weirdly, if I start from scratch, open a new workbook, then developer and insert just one module and then delete it, that's ok. I can do that repeatedly. Opening and closing form windows in the developer doesn't show the same problem. It isn't just one particular macro enabled workbook that is triggering the problem. Sometimes the workbook opens without macros enabled and I close it without enabling macros and the problem has been triggered. I have switched off all addins. I did recently activate the Inquire COM addin. My excel version is MS Excel for.365 MSO (Version 2604 Build 16.0.19929.20096) 64-bit running on Windows 11. I don't know when I first saw this but I think within the last month. It's a company laptop with phone IT admin support so I'm limited on the trouble shooting I can do myself. Office 365 has been uninstalled and reinstalled but did not help. Other users in my organisation are not seeing the same issue when they open the same workbooks. The IT admin however told me they did see the issue. Updated. Starting from a clean state after reboot, I open a new workbook, add several blank VBA modules then save as xlsm and close. Then when I open a new workbook the problem is triggered again. No VBA code has been run or written. Updated If I maximise the VBA module windows before closing them then I can close them without crashing!73Views0likes1CommentSeries fill a formula down a column automatically skipping a set number of rows
I am trying to fill a formula down a column every 6th row but incrementing the variable in the formula ($A2) for each entry. The formula uses the Take command and inputs 5 rows of data, so to keep it from "spilling" I need the formula to increment every 6 rows, having one blank row between each section. I have been able to accomplish "copying" it each 6th row with VBA #1 and filling the series with VBA #2 but can't figure out how to combine the two. Any help would be appreciated. VBA #1: Sub FillEvery6thCell() Dim ws As Worksheet Dim startRow As Long, lastRow As Long, col As String Dim formulaText As String Dim r As Long ' Set your sheet and parameters Set ws = ThisWorkbook.Sheets("Top 5 Employees") col = "A" ' Column to fill startRow = 10 ' First row to start filling lastRow = 60000 ' Last row to fill ' Get the formula from the starting cell formulaText = ws.Range(col & startRow).Formula ' Fill every 6th cell For r = startRow + 6 To lastRow Step 6 ws.Range(col & r).Formula = formulaText Next r Range("A2:A60000" & iRow).Replace What:="@", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2 MsgBox "Formula copied to every 6th cell in column " & col End Sub VBA #2 Sub FillFormulasDown() Dim sourceCell As Range Dim fillRange As Range ' Define the cell containing the formula Set sourceCell = Range("A2") ' Define the target range Set fillRange = Range("A2:A5000") ' Fill formulas down sourceCell.AutoFill Destination:=fillRange, Type:=xlFillSeries End Sub86Views0likes6CommentsMATCH formula anomaly?
Can anyone explain this? If I simply type 490.44 and then calculate 490.44 as 490.44/40*40 (or even directly B3/40*40) excel recognizes both as equal through a simple A=B calculation yet not with a MATCH calculation. What is more odd is any other number I use does not cause this error...Solved90Views0likes3CommentsExcell function problem
I have been using Excel for a good few years, i have a spreadsheet that has been working fine until now. My main problem is that when i copy & paste data everything works fine, i have been able to add cells to make a new total. but when i cut & paste the value of cells i get a REF error. so when i need to move a series of cells higher or lower any cells that contain word they move fine, the cells containing numbers move but the cell with the function just goes to #REF, the function was working okay with my previous versions of Excel but now it will not. if anyone has got any idea what the problem is or any way of fixing it i would be most gratefull29Views0likes1Commentsort by column then by numbers in a row
HI all I have a table of results pictured here. Once the results are in, I sort the table by the Total Score Column. When we have a tie (as in line 3 & 4, I need to sort by who has the most highest score... so, who has the most 9 (equal here), then by most 8.5 (line 4 wins the tiebreaker, 4 over 2) Can I do this so it doesn't affect the order of the columns but just the rows involved.236Views0likes7CommentsPower Query Editor - Unpivot Multiple Delimited Columns
Hello- I'm looking for the most efficient way to unpivot multiple columns that have delimited data. For example, I have the following data: Date User Product Position Job 1/1/2026 1234 ABC Position 1 | Position 2 Job 1 | Job 2 1/1/2026 5678 DEF Position 3 Job 3 And I'm looking for the data to be as follows: Date User Product Position Job 1/1/2026 1234 ABC Position 1 Job 1 1/1/2026 1234 ABC Position 2 Job 2 1/1/2026 5678 DEF Position 3 Job 3Solved62Views0likes2Comments