All Questions
Tagged with microsoft-excel-2016 office365
13
questions
0
votes
1
answer
1k
views
Excel summary page that auto populates from sheets
I have a problem with excel that may not be possible. I have a workbook that contains a list of sheets with various projects e.g. 'project 1' is a tab, 'project 2' is a tab etc. I now need to ...
- 1
0
votes
1
answer
3k
views
Excel Pivot Charts - Creating different charts (with different grouping) from the same data
I would like to create (at least) two pivot charts sourced from the same data that display the data in different groupings; one will be grouped by years, the other grouped by months. I am able to ...
1
vote
1
answer
554
views
Can I add Png Image as an option to Create New Object Type in Excel 365?
I want to insert several pictures as Objects in Excel 365. These pictures are scans of construction plans that serve as references to some calculations in the file. File readers need to be able to ...
- 23
0
votes
0
answers
46
views
Excel's IRR function seemingly differs from actual math
I am currently developing a web application that will have to do IRR calculations and as such need to develop a math formula for it.
Never the less, after messing around with online formula's. I ...
- 103
1
vote
1
answer
2k
views
Excel 365 Slow Scrolling due to Notes and Comments
An Excel spreadsheet containing any 'notes' (previously known as 'comments' in some earlier Excel versions) is slow to scroll up and down when holding down the up/down arrow keys. For example, even ...
- 21
0
votes
1
answer
1k
views
Excel - How can I probe all the precedents of a given cell?
I'm a relatively naive excel user who's been dropped in the middle of an ocean of cells. I've been tasked with coding the value of one cell in a workbook into python. Of course, this cell has multiple ...
- 101
6
votes
2
answers
8k
views
How to disable/enable office clipboard
Question: Is there any way that you can disable clipboard in Office 2016?
I don't mean show/hide status when coping or similar stuff from clipboard options. I mean to completely turn it off. It so ...
- 499
4
votes
10
answers
78k
views
How to rectify Excel error "We couldn't get the data from table in the workbook..."
I am dealing with the following problem using MS Excel 2016:
The Excel file contains a huge data table and several pivot tables in separate sheets.
The current Excel file was saved under a new file ...
- 41
-2
votes
1
answer
102
views
How to remove duplicated entries, and only keeping one entry per user per course
Needed help here!
Here, for example, the title (the title of a course), required date (the date they required to retake the course), and the completion date (the completion dates that a employee ...
0
votes
1
answer
867
views
COUNTIFS with >=, wrong data type
I can't get my excel formula working. ZÄHLENWENNS is COUNTIFS
=ZÄHLENWENNS(A:A;A2;C2;C2>=18)
I always get:
A Value used in this formula is of the wrong data type
Here is an excerpt of the ...
- 177
0
votes
1
answer
93
views
How Can I Streamline Modifications to Multiple Identical Excel Tables?
We use Excel for Mac to track our business' daily services rendered. We have 31 identical tables on one worksheet, each of them for a single day. Another worksheet then totals the entire month's ...
- 1
0
votes
1
answer
2k
views
In Office 365 - Excel 2016, how do I protect the file to require a password to modify it?
I remember back in Excel 2010 it was possible to set a document as for the user to be open to read only and if you wanted to make changes, you had to input a password to do so.
We're using Excel 2016 ...
- 3
1
vote
1
answer
329
views
How can I enable my worksheets in Excel to auto-update the filters I have applied to them
I have looked on the other threads to no avail for this. I have a few sheets in my workbook, with one being a data sheet and the others pulling data from it. I have set a filter in these sheets to not ...
