What can't be done in Excel ?
What can't be done in Excel ?
When I ask customers why they're not using Excel for more things, they often say to me: "Well, we'd like to do XXXX, but you can't do that in Excel can you ?"
Often, the answer is: "YES YOU CAN !"
So my question to all of you, is this: What do you think can't be done in Excel ?
Nick
»
- Nick's blog
- Login or register to post comments
- 15709 reads
Undo a selected cell in an individual multiselection
First Thanks for your sharings.
This, until now I can't do yet in excel.
How to Unselect a cell when I'm doing individual cells selection. once you go for more than 10 of them, you need to start over and it always bothers me :)
Do you agree to this Nick?
Cheers
hadi
ur right.. u can't unselect
ur right.. u can't unselect cells from multi-select..however, there might be a few ways round. If it's the same range that you are multi-selecting each time, why not name the range ?.. then you can go to the range.
reading/seperating range of numbers
I've been trying to get excel to read an input like "5-10" as "5,6,7,8,9,10" I need excel to be able to distinguish any combination of ranges like 6-12, or 102-220 etc all reading the data as seperate numbers. can this be done? and if it can is it going to take heavy VBA programming?
Multi-threading
Hello
I dont know f anyone who's used Excel or VBA for multi-threading programming.
I work on valuation and Excel modeling and any complex (and sometimes not so complex to be fair) calculation has to be taken out of Excel to C++, C#, etc.
I think professional level multithreading is something out of the scope of both Excel and VBa.
Thanks
JA
multi threading
yes, agreed.. although it has to get pretty complex before you need multi-threading.
I hear Excel 2010 improves on this aspect, although I have not played with it yet.
Windows API
Just to add that calling the Windows API from VBA is not a solution. It actually brings a new host of additional problems.
We probably need to accept that Excel/VBA simply cannot do it.
Very limited at analysising stock prices
Excel is good at somethings, but quickly runs out of steam. E.g. backtesting. Great for a single stock but not great if you want to write lots of indicators etc or run through lots of symbols. There are several solutions out there that download stock data into excel but they are so unscalable that it really sucks for anything more sophisticated.
Mark
Limitations of Excel
Hi Mark
I feel your pain, but there are utilities out there that solve this problem by storing the data in memory and allowing you to access it through Excel.