Indicator on file icon for files on sharepoint that are booked out. (Excel especially, for administrative maintanance.)
The idea is to see which files are locked by online users who are busy working on files (Excel specifically).
This means that there should be an indicator on the file icon in the browser, that works the same as the sync feature (the animated circling arrows that shows a file is in the process of being uploaded/synced).
This will make choosing a file for editing (maintanance) easier using Excel offline.3 votes
HEX2DEC should be able to process 64bit quantities. Figuring out we can write a formula like this to process such a quantity by parts ... just should not be necessary:
When you edit a hyperlink (eg the screentip or URL), the formatting gets set back to default hyperlink styling (eg blue underlined Times New Roman). I use completely different styling for hyperlinks (Wingdings, with conditional formatting defining the font colour) and it's so frustrating having to re-apply the formatting once you have edited a detail of it.2 votes
Give us back our formatting windows, instead of the ridiculous formatting sidebars for objects, among other things.
Give us back the formatting windows, instead of the formatting sidebars for objects in Excel 2016. It is impossible to navigate the sidebars using the keyboard, as one used to the windows, significantly decreasing productivity.2 votes
When querying a SharePoint list, it brings dates back as American format and not regionalised. Even though in SharePoint the date settings are set correctly to New Zealand, dates are incorrect. This also happens in Power Query in Excel and PowerBI. They display correctly in SharePoint. The query brings them back as Text, which also fails when converting to dates because our regional format is dd/mm/yyyy so any date like 16/11/2016 fails and gives an error. This makes querying SharePoint not really usable in our region. It also doesn't bring back timezone information.2 votes
I refer to the "Find // Replace" function within the "Find & Select" option.
It would be much more useful if:
a/ The "Find NEXT" would could be toggled to search backward
b/ That one was able to set personalize the DEFAULTS within the Options window
Thank you4 votes
Display of multiple data-sets in a single chart does not only require multiple y-axes, but often multiple x-axes as well. It would be of great help to have the option for at least 2 x-axes2 votes
When i build a combo chart, some items are on primary axes and some on secondary because of different scales.
However, the labels are all mashed up into one giant box. It would be far better if the labels were shown on the same axes as the data series. It would make the chart much more self-explanatory.2 votesScott Ruble (PM MSFT) responded
Can you provide an example and steps for the problem that you are describing? Its not clear what you mean by “mashed up into one giant box.”
Excel is throwing me a #NUM! error when I try to use the NORM.INV function. This error is pretty much useless. The Excel application knows why it's throwing the error. Either I haven't loaded the function yet (and why would I need to, BTW), or it doesn't like one of the inputs. Rather than showing #NUM!, do something useful and give a detailed error.2 votes
By IBCS, I assume you are referring to “International Business Communication Standards”. Could you provide more detail on what you are specifically looking for? IBCS is pretty broad.
If I have a workbook open and want to open another workbook, I would like an option to open within the same folder and not picking 'Browse', 'Recent Location' etc. If I use the 'Save As' button it does that, but 'Open' no longer does. Maybe an 'Open In' button? Thanks Microsoft for the opportunity to provide feedback!3 votes
These are the existing format options available in excel
in most of my business cases i miss all the below fields
Website url map
Social Facebook Twitter
Contact Mobile landline
Pincode Country state
Poll Q1 Q2 Q3
Apps App URL
it would be great if Office can consider adding more formating options
in word,excel etc3 votes
ability to have multiple relationships between tables in power pivot4 votes
you cannot change the data source for 2 or more pivot tables (conneceted to the same data source) that "share" the same slicer.4 votes
In PivotTables with many Value fields it is annoying to change them all from SUM to COUNT. Make this easier.
In PivotTables with many Value fields it is annoying to change them all from SUM to COUNT. Make this easier.4 votes
It is necessary to add A UNIVERSAL SHEETS AND WORKBOOKS MANAGER similar to file manager for OS. Plus different small features as toggling, vertical tabs and so on.2 votes
Can you give more details on what you mean by a universal sheet and workbook manager?
1040 Tax forms in PDF form can be coped to excel as a picture. I need a way to cut holes (boxes) to access various Excel cells to make activ
1040 Tax forms in PDF form can be coped to excel as a picture. I need a way to cut holes (boxes) to access various Excel cells to make active forms (adding subtracting, multiplying and other functions) would then be available.2 votes
Directional sumproduct(a1:a10;b10:b1,c1:c10...) allowing one column to proceed downward, other proceed upward
There is a new, super-powerful and easy method of solving systems of differential (and ordinary)-value-problem equations: the Parker-Sochacki solution to the Picard iteration (see Wikipedia, or ARXIV papers/1007/1007.1677.pdf for a how-to). It's easy enough to do by hand. But it requires a sumproduct that allows some columns to go forwards, while other columns go in reverse. It isn't practical to reverse the column with lookups (it's an iterative thing); and it's super-slow using visual basic. However, it should be super-easy to modify sumproduct() to do the job. Call it FRsumproduct(), and either allow a initial prefix string that tells the direction of summing ("FRRFR", a1:a10,b1:b10), or alternatively allow the arrays to be defined and remain in reverse, if excel is set up to allow that.
There is a new, super-powerful and easy method of solving systems of differential (and ordinary)-value-problem equations: the Parker-Sochacki solution to the Picard iteration (see Wikipedia, or ARXIV papers/1007/1007.1677.pdf for a how-to). It's easy enough to do by hand. But it requires a sumproduct that allows some columns to go forwards, while other columns go in reverse. It isn't practical to reverse the column with lookups (it's an iterative thing); and it's super-slow using visual basic. However, it should be super-easy to modify sumproduct() to do the job. Call it FRsumproduct(), and either allow a initial prefix string that tells the…2 votes
- Don't see your idea?