All Questions
Tagged with microsoft-excel-2016 windows-10
38
questions
0
votes
1
answer
749
views
Pinned files are not unpinned on the taskbar in pinned applications
The problem is this. Excel is pinned to the taskbar.
When you right-click, a list of pinned files and recent files appears. Some files in the Pinned ones cannot be unpinned from the list. The files ...
0
votes
1
answer
4k
views
Excel CTRL-V not working properly
Edit This can be worked around by cutting the text from source cell in the cell-edit mode but it's a bit cumbersome. The paste-in-cell-edit fails even if the target cell is empty.
Excel 2016 + Win 10 ...
- 310
0
votes
1
answer
36
views
Macro to skip filtered rows
I have the following macro which does the following:
Get the file names from a folder on Windows - this is only done if the list and folder is sorted A to Z
Combines the name with the folder name
...
- 1
0
votes
1
answer
57
views
Sorting and ordering two expense lists by a third list of categories using Excel 2016
I want to use Excel 2016 to sort two expense lists by a third list of categories.
The first catch is that I want to place the value in the same cell like the categoris list – It's not a simple sort, ...
- 147
0
votes
1
answer
828
views
Cannot save excel 2016 document located on server after resuming from hibernation
Problem description:
I have an Excel 2016 spreadsheet open and saved on my file server.
I hibernate my Windows 10 leaving the spreadsheet open.
I Turn on my Windows 10.
I edit my spreadsheet.
I try ...
- 251
0
votes
1
answer
4k
views
Why does an Excel workbook file open automatically?
I have the strange case of 2 nearly identical Excel workbook downloads in my code, and often on another team member's machine, and sometimes on my machine, when the user clicks download, the .xlsx ...
- 2,651
0
votes
0
answers
28
views
Slicers are changing width on pivot refresh
I have a strange problem. There is a pivot table on separate sheet from the data(Data is a table) and there are about 6,7 slicers for that pivot. When I add new data to Data Table and do "Refresh All" ...
- 499
0
votes
0
answers
373
views
Windows 10 Clipboard Not Copying New Content
Salutations,
INTRO:
I am running into a bizarre situation regarding the windows 10 clipboard, excel, and Microsoft SQL manager. I provide support for the user that has this problem and hit a bit of ...
- 1
0
votes
3
answers
6k
views
Excel "Can't find Project or Libary" - but which one?
Using Office 2016. I have an Excel file with VBA. Whenever I open it, I get the error "Can't find Project or Library". Excel immediatlely closes.
I opened Excel and, without opening the file, looked ...
- 233
0
votes
1
answer
1k
views
Adjust row height in excel from INDEX formula
I have some cells whose content is determined by an INDEX formula. They are horizontally merged cells, on a single row.
The content they can show is quite variable in length, so the cells are set to ...
- 119
0
votes
0
answers
20
views
Excel 2016 how to autofill data entries based on a reference sheet
I have an Excel document where I input monthly sales to analyze via pivot tables and graphs. The software I export sales data from exports it in the following way:
MONTH | PRODUCT ID | PRODUCT NAME | ...
1
vote
3
answers
12k
views
Convert one column into a new column every 10 rows in Excel
I have a set of 110 numbers in Excel. I want to split this into 11 columns of 10 rows each.
So, for column:
324
292
300
120
276
320
984
136
300
280
69
289
266
292
266
494
315
118
295
289
I want ...
- 13
-1
votes
2
answers
968
views
How to stop Excel from generating lots of rows and columns when making a new file?
When I open a new file in Excel, it makes a large amount of rows and columns, instead of a set amount. How do I delete all these columns and rows? They are useless to me.
3
votes
1
answer
2k
views
Why does Windows Defender slow my Excel file saving, even if the xlsm file type is excluded?
I'm experiencing a strange issue with Microsoft Excel (Office 365 MSO 16.0.11126.20234 32B) and Windows Defender running on Window 10 Pro (1809 Build 17763.253 64B) . When I save a macro-enabled Excel ...
- 131
0
votes
0
answers
2k
views
Excel double click autofill not working on non-empty merged cells
In Excel (latest 2016 Professional Plus version 1811 on Windows 10) you can copy the formula in a selected cell (cells) down by double clicking on the dot in the bottom right corner. This also works ...
- 111
0
votes
1
answer
134
views
Excel formulae for priority sections
I would like to add the date C6 to E6 (if P1=30 days, if P2=60 days, if P3=90 days, if P4=1 year) and show total in I6
- 1
0
votes
0
answers
74
views
True/False for two arrays having 1+ values that are the same
Edit note: The problem has changed slightly since first posting; see edit
So I'm looking to check two arrays (of strings or integers/floats; although it'll be the same for both arrays) and get a True ...
- 101
1
vote
1
answer
2k
views
How do I disable Excel touch scroll bounce at top of sheet?
How can I disable Microsoft Excel's sheet overscroll bounce animation when touchpad scrolling to the top or left of sheet on Windows 10?
You can see what I mean by the video here, https://imgur.com/a/...
- 3,812
1
vote
1
answer
225
views
Formula to SUM values in mulitple columns, based on criteria from another column
I have a sheet with three columns. The first is called "Account Number" (AccNr). The two other contains values related to each account number. It looks like this:
AccNr. | Value 1 | Value 2
1000 ...
- 13
0
votes
1
answer
923
views
Microsoft Excel date reversed in Formula Bar
I have just been forced to upgrade to Office 2016 by my employers. Ive been having all sorts of problems with it. The latest problem is entering dates. I know how to enter custom date and have been ...
- 1
1
vote
0
answers
158
views
Excel Worksheet Change event not firing unless cell is manually changed for the Private Sub Worksheet_Change_D
All the code works except the Private Sub Worksheet_Change_D(ByVal target As Range). The column I8:I200 has formula that shows updated change from another sheet. If I8:I200 shows as completed, then ...
- 11
4
votes
3
answers
5k
views
How to delete multiple non-adjacent columns in Excel at the same time?
When I select multiple (non-adjacent) columns and try to delete them in one move, Excel grays out the options for deleting columns. The column deletion options are only available when I select ...
- 41
1
vote
1
answer
94
views
Compare list contents in excel
So here's my situation: I am creating a sheet where I have 9 groupings of 3 lists where the items chosen are all contained in lists made via data validation. What I need to do is add a score to each ...
1
vote
0
answers
59
views
Excel 2016, First Friday or Monday of year
If I have a year (In text Form so it can be changed by user) in cell J2.
How do I calculate which is first Friday or Monday of the year (Whichever comes first in the year)
Thanks in advance.
- 11
0
votes
0
answers
4k
views
Excel 2016 workbook with VBA shuts down immediately after opening it
I built an Excel workbook (CPD.xlsb for reference). It has extensive VBA programming, including code that executes when the file is opened (Private Sub Workbook_Open() etc.).
The workbook has been ...
0
votes
1
answer
1k
views
How do I find & replace multiple values in Excel 2016
Here is my problem. I have a large spreadsheet, about 3,500 rows and 10 columns, and want to replace a number in one column with a text value. Find and replace works fine for an individual find and ...
- 1
0
votes
1
answer
82
views
How do I round up the output of a formula in Excel 2016?
I have a formula in Excel:
=(1+E20+F20+G20)/4
The output is 3.25. I want 3.25 to be rounded up to 4. How do I do that in the same cell? The ROUNDUP function seems to only be used when referencing ...
- 1,637
0
votes
1
answer
60
views
Stop Excel from Inserting ###
So when a column is too short in excel it will replace the values with ####. Now if I expand the cell out I can see the dates that are in there.
I've been looking all over and can't seem to find a ...
- 185
9
votes
2
answers
8k
views
Inactive window scrolling not working with excel
Inactive window scrolling:
With windows 10 there is a new feature called inactive window scrolling, which means if your mouse hovers over a window you can scroll on it, without it needing to be the ...
- 193
1
vote
1
answer
2k
views
Excel bar chart: Plot some categories (not series) on a secondary axis
I am trying to produce a bar chart that shows the change in 6 variables over two periods. 5 of the variables are percentages, so they are bounded at 100%. The other variable, "number of committee ...
- 157
0
votes
2
answers
3k
views
PivotTable Change Data Source broken in latest version (1706)?
Create a sheet "2015":
Create a sheet "pivot" und sum the amount:
Create a sheet "2016" with different data
Try to select the data from "2016" for the pivot table and hit the OK button and nothing ...
- 101
0
votes
1
answer
50
views
Creating a graph from a table with time differences
How do I create a graph like this
from a table that looks like this
startTime;endTime;Name
00:00:04;23:59:57;Peter
00:00:00;23:59:59;Frank
...
?
- 201
0
votes
0
answers
3k
views
Missing Date/time picker in Excel 2016
I have a new Windows 10 laptop with Excel 2016. I need to support a spreadsheet that has a datetime picker.
When I start the spreadsheet, I get an error "Could not load an object because it is not ...
- 2,400
0
votes
2
answers
2k
views
Tracking work schedule and calculating work hours using Excel
I have to make a schedule in a calendar format every month and I often make changes of where people go and when people work.
If there is a way, I would like to use a formula that will track each name ...
-1
votes
1
answer
196
views
Extraneous column and row headings appeared in Excel
Two rows and two columns appeared in a worksheet when Excel updated. They are above the Column headings and to the left of the row headings, both labeled 1 and 2. If I click on 2, I get the normal ...
- 9
0
votes
0
answers
110
views
Reorganize data in Excel
I have a list of (let's say) phone numbers and people. Each person has a varied quantity of phone numbers. I have the data arranged with phone numbers in column A and the owners in column B.
I want ...
- 11
1
vote
0
answers
336
views
What is this extra drop down in Excel, and how do I get rid of it?
In Excel, I have two adjacent cells with the same Data Validation applied.
When selected, the bottom one has the appropriate drop down widget to the right. Clicking on the widget works normally, ...
- 1,304
4
votes
3
answers
6k
views
fix for unhiding column in Excel has stopped working
I have just moved to Windows 10 and Excel 2016 (from Excel 2000) and found that CTRL-SHIFT-0 no longer works to unhide columns, because it's been hijacked by a language setting (for hotkeys for ...
- 41