Live data from Hacker News

Ask HN: What can't you do in Excel?

news.ycombinator.com

21–30 of 201 posts

Re: Ask HN: What can't you do in Excel?

#21
I think something that google has begun to do, and that is incredibly valuable, is data "sources" that aren't hard coded into any particular spreadsheet, but that come from a URL or API of some kind.

I should be able to make a row of "oil prices by month since 2005" that updates on its own. Or a cell with "current value of the DOW".

Re: Ask HN: What can't you do in Excel?

#24
I'm exactly the opposite of your target audience with this question, but hopefully I can give a useful response anyway :)

I know almost nothing about Excel and it's a deficiency I feel quite keenly. The program is almost completely undiscoverable to me and I don't even know where to start with it. I know that there are powerful uses and features of Excel but the model (or at least the bits of it I've been exposed to) hasn't clicked for me yet.

I suspect I'm not alone in my bafflement; maybe there is the possibility this new spreadsheet could be useful to us Excel-ignorant customers who nonetheless want access to the benefits of this class of software.

As a hacker and programmer who is comfortable with all sorts of paradigms I feel really strange admitting this weakness but I suspect that I'm not the only one who is in this boat.

Re: Ask HN: What can't you do in Excel?

#25

Here are some features that would be nice in Excel: 1. Programmability in something other than VBA (Python?). 2. Online spreadsheets like Google. 3. Better search and replace. 4. Ability to reference tables through URLs so they could show up in blogs and in HTML. Something like this: http://ycspreadsheets.com/joe/doc1.ss?s=1&block=a1:c10. This should produce HTML that some javascript can replace in my blog with the t…

I thought number 5 was already possible in excel :/

Re: Ask HN: What can't you do in Excel?

#26
post #17
post #9

Automatic versioning and version control.

Did you try Sharepoint? It does versioning, version control and a bit of collaboration for Excel.

Sharepoint is fine if you are only tacking things at the file level. You can't answer stuff like "who changed the formula in E5?" Or even "how long has the formula in E5 been wrong?"

Some kind of auditability of Excel spreadsheets would save enormous amouns of money and time.

Re: Ask HN: What can't you do in Excel?

#28
I would like to have mind mapping (like http://www.mindjet.com/) right inside excel (as well as for other office applications) but it should be tightly integrated. It seems to me such type functionality might be useful for data crunching and modeling with full brain thinking. Spreadsheets enable only logical half of brain so there is room for improvement.

Re: Ask HN: What can't you do in Excel?

#29
post #17

Earlier quoted context omitted.

Did you try Sharepoint? It does versioning, version control and a bit of collaboration for Excel.

Sharepoint is only really an option if all your users are on Windows.

Not really. You sacrifice some functionality, but you can still use Sharepoint from a Mac.

http://www.microsoft.com/mac/itpros/default.mspx?MODE=ct&#38...

No Linux support of course.

Re: Ask HN: What can't you do in Excel?

#30
post #17

Earlier quoted context omitted.

Did you try Sharepoint? It does versioning, version control and a bit of collaboration for Excel.

Sharepoint is fine if you are only tacking things at the file level. You can't answer stuff like "who changed the formula in E5?" Or even "how long has the formula in E5 been wrong?" Some kind of auditability of Excel spreadsheets would save enormous amouns of money and time.

You can diff two versions against each other.

Of course it's not as nice as "blame", which I think is what you want here?

Post reply on HN