What can't be done in Excel ?

Nick's picture



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

 

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

Nick's picture

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

 

Nick's picture

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

Nick's picture

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.