121–130 of 275 posts
Hey, I work on Excel at Microsoft and wanted to say: if anyone here has any feature requests they want escalated - write them here and I will bring them up. P.S we actually do read all the feedback people leave in the feedback box - it goes mostly straight to the devs.
Please bring back CTRL+SHIFT+V as paste values only
Hey, I work on Excel at Microsoft and wanted to say: if anyone here has any feature requests they want escalated - write them here and I will bring them up. P.S we actually do read all the feedback people leave in the feedback box - it goes mostly straight to the devs.
Right now I use Python and Pandas, mostly doing the same stuff but with more rows and a worse experience. If you could find an easy way to combine Python and Excel it would be awesome. Like embedding Python instead of VBA? Would need sandboxing.
Earlier quoted context omitted.
> From experience, most Excel solutions are due to people refusing to use whatever solution their ERP system is offering. From experience, most Excel solutions are because people get rebuffed (or have learned by experience that they will expend lots of effort and the be rebuffed or given something not fit for purpose) by the bureaucratic processes necessary to get anything provided to them by their enterprise systems…
As part of that priesthood, Excel is neither SOX nor otherwise compliant. If users get rebuffed, that is the overall system working as intended.
Hey, I work on Excel at Microsoft and wanted to say: if anyone here has any feature requests they want escalated - write them here and I will bring them up. P.S we actually do read all the feedback people leave in the feedback box - it goes mostly straight to the devs.
Hey, I work on Excel at Microsoft and wanted to say: if anyone here has any feature requests they want escalated - write them here and I will bring them up. P.S we actually do read all the feedback people leave in the feedback box - it goes mostly straight to the devs.
I recently sat down and built something more complicated than simple accounting in a spreadsheet. It's what I considered to be a pretty typical usecase for a non-math related sheet; taking in several tables of data and selectively joining them. You enter an ID, press a button, and it finds all of the data related to that ID and presents it to you. I was horrified to find that even with the supporting scripting capabi…
Just record yourself finding the bottom of the data set (Ctrl + down arrow), then take a moment to make the code work in relative terms instead of absolute terms.
What.
Does the author actually believe this? Every single example of a company that switched from something I could buy to making me rent it instead has ended up costing me more money and given me a worse product that is constantly at risk of >poofI'll totally buy the rest of the quoted sentence (e.g. about recurring revenue) but the part I quoted above is absolute arrant nonsense.
Excel is great, but sometimes it can be abused. I have seen some horrendously complicated VBA sheets that are so much simpler to program in any procedural language. If you want to create or read Excel spreadsheets programmatically, I recommend LibXL, a simple and powerful C++ library. https://www.libxl.com/ (I am a customer, am not associated with them).
Can you expand on that? My view of VBAis that it is a dated, but pretty much standard procedural language.
It's not the VBA that is the problem. It's the disparate scattering of business logic.
Don't get me wrong: Excel is brilliant for some things. But it has been extended beyond reason by wannabe programmers in the accounting department who discover they chose the wrong career.
Hey, I work on Excel at Microsoft and wanted to say: if anyone here has any feature requests they want escalated - write them here and I will bring them up. P.S we actually do read all the feedback people leave in the feedback box - it goes mostly straight to the devs.
Lambdas are awesome but the ui and their management could use some work. It would be great to have a “script” view to manage defined names instead of hacking them one by one. Single line entry isn’t efficient and the default assumption that cursor keys navigate a sheet instead of the formula box, is annoying. I find myself copying formulas out of excel, modifying them in a text editor, and pasting them back.
Hey, I work on Excel at Microsoft and wanted to say: if anyone here has any feature requests they want escalated - write them here and I will bring them up. P.S we actually do read all the feedback people leave in the feedback box - it goes mostly straight to the devs.
Wait really? Well if thats the case, making VLookups be able to use any column as an input or output, rather than being limited to having the input on the left and the output on the right. Ideally I'd be able to have 2 additional parameters, one that would indicate the column where the input value is to be found, and another that would indicated the column from which the output value would come from. I know there are…