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".
Ask HN: What can't you do in Excel?
21–30 of 201 posts
Re: Ask HN: What can't you do in Excel?
#22If I'm going to make a scatter plot style plot for anything besides an internal memo (even an internal presentation) I always plot with something else.
Re: Ask HN: What can't you do in Excel?
#23Re: Ask HN: What can't you do in Excel?
#24I 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?
#25Here 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…
Re: Ask HN: What can't you do in Excel?
#26Automatic versioning and version control.
Did you try Sharepoint? It does versioning, version control and a bit of collaboration for Excel.
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?
#27Re: Ask HN: What can't you do in Excel?
#28Re: Ask HN: What can't you do in Excel?
#29Earlier 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.
http://www.microsoft.com/mac/itpros/default.mspx?MODE=ct&...
No Linux support of course.
Re: Ask HN: What can't you do in Excel?
#30Earlier 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.
Of course it's not as nice as "blame", which I think is what you want here?