Tried Money in Excel today with a new subscription to MS 365. It seems to show only the total account balance but does not download holdings and investment transactions at this time.2 votes
Thank you for using Money in Excel.
Since you mentioned that the template doesn’t show investment transactions, kindly confirm which financial institution are you using with Money in Excel so that we can review the issue.
The Microsoft Team
Whenever I scroll too fast in Excel on my PC black and grey boxes appear everywhere and cover what I am working on. This is incredibly frustrating because there is no way to get rid of the boxes.
This only happens on my external display and it only happens in Excel.
Please fix this issue.100 votes
I am not seeing new recent activity in this space. It is possible you are seeing this less due to our on-going performance investments including in speeding up our grid rendering. Details on latest speedups are at https://aka.ms/excel-perf-improvements.
That said, if you still are experiencing this please provide specifics on your configuration and monitors… better still please send feedback about the problem from within Excel (go to Help > Feedback), which will include some diagnostics to aid our investigation.
When I close a spreadsheet, it is the size I want it to be. But when I reopen it, Excel is as likely as not to have "decided" that it knows better than I do what I want, and it reopens in a different size. Sorry, but I do know better than Excel does what I want, and resent the arrogance displayed in changing my preferences. Make it stop!!!124 votes
When you say that it opens a different size – can you give more info? Do you mean the application window is a different size (it shouldn’t be) or that the font sizes (zoom) are different? (again, they shouldn’t be)
Additionally, if you can post a video of what you’re seeing, that would be a big help for us.
If there is a problem here, it’s definitely something we’d want to fix.
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.
Add a setting called
"Open text-delimited files (CSV, etc) as text only, with no type inference."
When this setting is active, then every column's format will be "Text" when a CSV or other such file is opened, so that the initial view is exactly the text represented in the CSV.66 votes
Thanks for the feedback!
Can you comment on whether you expect this to basically import all the lines as text to column A, or if you have some other expectation?
Also, I’m assuming people refer here to the file/open path, and not to the Data/From-Text or New-Query/From-Text path.
I need to create a matrix in Excel that doesn't aggregate (e.g. Sum/Count) values. The question of how to do this has been asked dozens of times online over the last couple of years, but still there is no solution. Can Excel therefore produce a plain matrix, or allow pivottables to output plain (unmodified) values from the data field list?52 votes
For technical or scientific data (eg band structures) we need many data series charted before narrowing down to fewer. The series limit is very annoying and has no fix except to go to open source or a different app.2 votes
Could you provide some additional examples or use cases where you need more than 255 series? We want to better understand the scenarios of usage.
Excel freezes; unstable can't handle large number of large files. New features are great but would rather have more stable product15 votes
Make it possible to generate my calendar insight for a group in the "template my calendar insight". For example for a mail group with approval or for a calendar group if it's shared.
A group insight will be very beneficial in decision making and improving productivity etc.2 votes
Can you give a bit more info about how you see this feature being applicable to and working in Excel?
- More inverse cumulative distribution functions (Poisson, Exponential, Negative Binomial, Weibull, etc.);
- Ability to confine the distribution between certain values;
- Ability to generate / simulate time series;
- Ability to sample/simulate all inverse cumulative distribution functions without continuously recalculating the workbook (ex. run the simulation behind the scenes much like the current IRR function operates though iteration);
- Ability to correlate distributions;
- Ability to run sensitivity analysis on the results;
It is currently possible to build all of the above functionalities through VBA but having dedicated tools will bring considerable efficiency improvements.
Thanks for logging this, Lyubomir. How do you do these today? Is deeper integration with R potentially useful for such scenarios, at least for the analysis?
Add Microsoft Access type Query and SQL tools, allowing easier criteria entry, sorting, creation of calculated fields, and even linking together tables sharing a common key.11 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?
I wish charts in Excel were more integrated with charts in PowerPoint - or maybe that XLS & PPT were one piec of software.4 votes
What type of deeper integration for charting are you looking for? Currently, most of the UI is shared and they use the same charting engine.
- Don't see your idea?