Stack Overflow
Stack Overflow

Questions tagged [excel-365]

265 questions
0
votes
1 answer

Excel - Refresh All duplicate pivot table propertis

Good day, the Refresh All function in Excel does not work properly for me. "Properties in Report" and "Properties in Tooltips" are duplicated. Procedure: After adding a pivot table and adding attributes, everything looks correct, and Refresh All…
Pavel Kučera
  • 119
  • 10
0
votes
0 answers

Existing VBA Macro from Windows 7/Excel 2010 Fails to Save .xlsm for some users upgraded to Win10/Excel 365

There are many questions like this one on the internet, but none of them has led me to a solution. Hopefully, I can find some relief here. I have a community of users who are currently going through a migration from Windows 7 to Windows 10, and…
mkltmsck
  • 1
0
votes
0 answers

Override Excel's new automatic addition of "@" sign in formulas

[EDIT] Ok so the solution is to use Formula2 or Formula2R1C1 instead of Formula or FormulaR1C1; just follow the link below in the third comment to understand better. I'll leave my question here because I've spent a long time searching on MS docs,…
flo5783
  • 697
  • 2
  • 6
  • 19
0
votes
0 answers

Average Monthly Report Excel

I am trying to get the average time it takes to complete a project. The excel sheet is constantly being updated. I used =AVERAGEIFS(L:L,D:D,">="&$O2,D:D,"<="&EOMONTH($O2,0)) which gives me you can't divide by 0 and I tried pivot tables and they are…
svjeller
  • 1
0
votes
0 answers

Office 2016 automation

I have an legacy Excel project that automates Excel 2007 on our server in order to produce overnight user-authored reports. It has worked fine but recently on trying to upgrade to Office 365 (also tried 2016) I came across a problem where it appears…
DaveC
  • 63
  • 1
  • 8
0
votes
1 answer

Detecting new Excel Spilling mode and resetting it

Excel has a new Spill mode with a special @ function to replace implicit intersections. It is not quite compatible with existing Excel. So it needs to be explicitly enabled. OK. I am not sure what enables it, but I suspect a vague prompt about…
Tuntable
  • 3,276
  • 1
  • 21
  • 26
-1
votes
1 answer

Curious behaviour of BYROW(SEQUENCE(...),...) construct

Background In recent work I attempted to use a construct of BYROW(SEQUENCE(...),...) to create a column of results. The results were not what I expected. As a result, I investigated and came across some curious findings - set out below. Whilst I now…
DMM
  • 1,090
  • 7
  • 8
-1
votes
1 answer

How do I HSTACK a variable number of columns in Excel?

I want to do some calculations on each of the columns of an array and afterwards I want to reassemble the columns into an array. BYCOL works great for the process part but it only allows returning a single value and not an array. I tried varies…
snth
  • 5,194
  • 4
  • 39
  • 48
-1
votes
1 answer

Copy Cells from Separate Range Without #SPILL

If any of the cells in Sheet1!D2:D40 contain "COMPLETE", I need cell F(row), from that sheet, to copy its contents to Sheet3!B(row). I've tried this using =IF, but that gives 39 rows of #SPILL!. I need the cells in Sheet3 to remain blank until said…
James Greene
  • 3
  • 4
-1
votes
2 answers

I am a having an issue in Excel using VBA code to number rows after a multi row paste operation

I have a number of data sources that I need to bring into excel for analysis. I start each data set by pasting a one line header on Row 1 starting in Column B that will go to Column "X" (each source has a different number of columns). Column A Row 1…
Jasin Jones
  • 1
-1
votes
1 answer

Excel, Load Sheet1 data to Sheet2, if Sheet1 rows increase Sheet2 rows should increase to show those data

I have Sheet1 connected to ODBC and loads data from mysql server. Now I have Sheet2, it needs to populate all the values (rows & columns from Sheet1). If Sheet1 refreshed from connection its rows will change, so now i want Sheet2 will have those…
arun
  • 4,595
  • 5
  • 19
  • 39
-1
votes
1 answer

Find the match or matches with most same values in the same columns

I want to find, based on the criteria of a match in my table, which match or matches have the most same criteria in the same columns with priority. Could u help me? I tried with countifs but no result. and i want for a big data thats an example.
Teronimo
  • 13
  • 1
-1
votes
1 answer

How to Count Sheet Rows and Display each Row Count on Totals Sheet

I have a sheet that has rows added to it each month (10,000 and growing). I have a module that copies the rows for each State to it's own sheet. I'm trying to add a Totals sheet that has each State's row total. It needs to automatically update…
Curtis Martin
  • 1
-1
votes
1 answer

variable referencing a cell date value not passing to a copy paste filter

I have a spreadsheet that operators input data in, with the A column being the date, and the data is input by row. The A column is a formula that adds +1 to the date in the previous cell, going all the way down recursively to auto-populate the date…
Bobby Tennison
  • 1
  • 1
-1
votes
1 answer

Excel Formula Help: Copying data from one worksheet to another after determining if one of two cells is populated with data

I have a need to combining several excel worksheets into a single Master list. I'm stuck trying to populate a cell in my worksheet with one of 2 values from another worksheet (Staging_2) in the same workbook. This formula, originating from my…
user20841964
  • 1
1 2 3
…
17
18