Do you have adblock enabled?
 
If you can read this, either the style sheet didn't load or you have an older browser that doesn't support style sheets. Try clearing your browser cache and refreshing the page.

(Tech Crunch)   Microsoft about to Excel   ( techcrunch.com) divider line
    More: Interesting, Microsoft Excel, Spreadsheet, Excel, Microsoft, Excel users rejoice, Spataro, Microsoft Office, company names  
•       •       •

2768 clicks; posted to Business » on 26 Sep 2017 at 3:20 PM (3 weeks ago)   |   Favorite    |   share:  Share on Twitter share via Email Share on Facebook   more»



32 Comments     (+0 »)
 
View Voting Results: Smartest and Funniest
 
2017-09-26 02:26:43 PM  
Is that supposed to be a pun? Word.
 
2017-09-26 02:29:53 PM  
Outlook of this happening is poor.  Trying to access and download that kind of data would take a lot of CPU power.  Point for trying.

/got nothing
 
2017-09-26 02:38:26 PM  
Because when I am pulling together a work related spreadsheet I really want Excel to be analyzing that information and helping me out with other data.  Can they guarantee that they're not harvesting information for resale?
 
2017-09-26 02:45:32 PM  
I'd love to know what the "new datatypes" are.

Strings that can play ads?
Integers that can show online help pages?

img.fark.net
 
2017-09-26 02:55:23 PM  
"Microsoft's Bing API"

HAHAHAHAHA, No.
 
2017-09-26 03:09:07 PM  
Yeah, when my customer's importing spreadsheet data, I want a bunch of exotic objects floating around that need to be identified and dealt with accordingly.  Nothing is quite as enjoyable as deciphering an impenetrable object while a customer is on deadline.
 
2017-09-26 03:24:51 PM  

BizarreMan: Because when I am pulling together a work related spreadsheet I really want Excel to be analyzing that information and helping me out with other data.  Can they guarantee that they're not harvesting information for resale?


i0.kym-cdn.com
 
2017-09-26 03:25:45 PM  

enry: Outlook of this happening is poor.  Trying to access and download that kind of data would take a lot of CPU power.  Point for trying.

/got nothing


studebaker hoch: I'd love to know what the "new datatypes" are.

Strings that can play ads?
Integers that can show online help pages?

[img.fark.net image 200x234]


Marcus Aurelius: Yeah, when my customer's importing spreadsheet data, I want a bunch of exotic objects floating around that need to be identified and dealt with accordingly.  Nothing is quite as enjoyable as deciphering an impenetrable object while a customer is on deadline.



I can normalize the damned data sets myself, thank you very much.  If it's so complicated that it needs outside sources to validate it, I will have constructed the data in a proper database to begin with.

Excel is for running straightforward calculations, displaying Q&D tabular information, and playing what-if scenarios with numbers.  Stop trying to make it into something it's not.
 
2017-09-26 03:35:10 PM  
"We think these apps still have a lot of life in them for just working on your content, but we do believe that these connections just makes it magical lucrative, invasive, and exploitative."

FTFY.

I'm tired of companies mining my data for their profit. I'm tired of having to find disconnected apps and turning off half of their "helpful" features to prevent them sending information about my usage, my content, my machine, and so on to themselves for reuse and resale.
 
2017-09-26 03:39:37 PM  

BizarreMan: Because when I am pulling together a work related spreadsheet I really want Excel to be analyzing that information and helping me out with other data.  Can they guarantee that they're not harvesting information for resale?


LibreOffice in for the win.
 
2017-09-26 03:40:35 PM  
Yo dawg, I heard you like pivot tables...
 
2017-09-26 03:42:29 PM  

FormlessOne: "We think these apps still have a lot of life in them for just working on your content, but we do believe that these connections just makes it magical lucrative, invasive, and exploitative."

FTFY.

I'm tired of companies mining my data for their profit. I'm tired of having to find disconnected apps and turning off half of their "helpful" features to prevent them sending information about my usage, my content, my machine, and so on to themselves for reuse and resale.


Your best bet is to stop using computers then, or some esoteric linux flavor.
It's just gonna get worse.
 
2017-09-26 03:48:30 PM  
I use spreadsheets for a lot of different things.  Mostly to display tabular data and to run tons of connected calculations.

For much of what I use it for, the Google or Libre Office equivalents do the job just fine, and exactly the same.  Except Google Sheets pivot tables suck...  What I don't know about those programs is how well they handle outside data connections.

That is the one thing I use Excel for that is different.  I connect directly to database views/tables and pull live data, which can then be used for whatever.

Has anyone used those non-Excel programs for that sort of thing?
 
2017-09-26 04:21:48 PM  

mrsleep: FormlessOne: "We think these apps still have a lot of life in them for just working on your content, but we do believe that these connections just makes it magical lucrative, invasive, and exploitative."

FTFY.

I'm tired of companies mining my data for their profit. I'm tired of having to find disconnected apps and turning off half of their "helpful" features to prevent them sending information about my usage, my content, my machine, and so on to themselves for reuse and resale.

Your best bet is to stop using computers then, or some esoteric linux flavor.
It's just gonna get worse.


Preaching to the choir. I've been the practical herald of doom on the encroaching appropriation of my data and hardware by folks looking to exploit both for their own gain.
 
2017-09-26 04:27:38 PM  
TLDR:
 M$ is now going to be data-mining your spreadsheet as you type it.
 
2017-09-26 04:59:32 PM  
FTFA: soon be able to tag a list of company names as - well - company names, for example. Once you've done that, Excel can pull in more information about the company from Microsoft's Bing API,

so, label a list as company names and get...pancake recipes?
 
2017-09-26 05:09:14 PM  

brainlordmesomorph: TLDR:
 M$ is now going to be data-mining your spreadsheet as you type it.


I hope it likes multithousand line sp[spreadsheets about fasteners
 
2017-09-26 05:16:38 PM  
Awesome. Another MS program that does all kinds of stuff I don't want it to do.
 
2017-09-26 05:18:14 PM  

durbnpoisn: I use spreadsheets for a lot of different things.  Mostly to display tabular data and to run tons of connected calculations.

For much of what I use it for, the Google or Libre Office equivalents do the job just fine, and exactly the same.  Except Google Sheets pivot tables suck...  What I don't know about those programs is how well they handle outside data connections.

That is the one thing I use Excel for that is different.  I connect directly to database views/tables and pull live data, which can then be used for whatever.

Has anyone used those non-Excel programs for that sort of thing?


OpenOffice and Libre Office can use ODBC connections to pull data from databases.
 
2017-09-26 06:47:09 PM  
=VLOOKUP($BJ69,'Politics'!FA:RK,42,0)

Clippy:"I've analyzed your formula and searched for relevant content. Dude, trust me...you do not want to go there."
 
2017-09-26 07:30:36 PM  
I'll be happy if they can make it not crash. That'll be the day.
 
2017-09-26 08:13:23 PM  

durbnpoisn: I use spreadsheets for a lot of different things.  Mostly to display tabular data and to run tons of connected calculations.

For much of what I use it for, the Google or Libre Office equivalents do the job just fine, and exactly the same.  Except Google Sheets pivot tables suck...  What I don't know about those programs is how well they handle outside data connections.

That is the one thing I use Excel for that is different.  I connect directly to database views/tables and pull live data, which can then be used for whatever.

Has anyone used those non-Excel programs for that sort of thing?


Tableau does that extremely well. Although its primarily for visualizations.
 
2017-09-26 08:17:01 PM  

RadiomanATL: durbnpoisn: I use spreadsheets for a lot of different things.  Mostly to display tabular data and to run tons of connected calculations.

For much of what I use it for, the Google or Libre Office equivalents do the job just fine, and exactly the same.  Except Google Sheets pivot tables suck...  What I don't know about those programs is how well they handle outside data connections.

That is the one thing I use Excel for that is different.  I connect directly to database views/tables and pull live data, which can then be used for whatever.

Has anyone used those non-Excel programs for that sort of thing?

Tableau does that extremely well. Although its primarily for visualizations.


Haha,,,  In no way is Tableau anything like Excel.  In fact, it can use Excel as a data source.
 
2017-09-26 08:19:51 PM  

durbnpoisn: RadiomanATL: durbnpoisn: I use spreadsheets for a lot of different things.  Mostly to display tabular data and to run tons of connected calculations.

For much of what I use it for, the Google or Libre Office equivalents do the job just fine, and exactly the same.  Except Google Sheets pivot tables suck...  What I don't know about those programs is how well they handle outside data connections.

That is the one thing I use Excel for that is different.  I connect directly to database views/tables and pull live data, which can then be used for whatever.

Has anyone used those non-Excel programs for that sort of thing?

Tableau does that extremely well. Although its primarily for visualizations.

Haha,,,  In no way is Tableau anything like Excel.  In fact, it can use Excel as a data source.


I know. The question was is there any other program that can connect to tables and live data.
 
2017-09-26 09:45:21 PM  
I love excel, as a physicist it is very handy.   This sounds annoying and like data mining to me.   I don't need Microsoft sending me ads via excel.
 
2017-09-26 10:45:23 PM  

donutjim: =VLOOKUP($BJ69,'Politics'!FA:RK,42,0)

Clippy:"I've analyzed your formula and searched for relevant content. Dude, trust me...you do not want to go there."


Pfft, amateur. Real Excel users run Index Match functions:
=INDEX(FA1:FA1000,MATCH(Boobies,RK1:RK1000,))
 
2017-09-26 10:52:31 PM  

BizarreMan: Because when I am pulling together a work related spreadsheet I really want Excel to be analyzing that information and helping me out with other data.  Can they guarantee that they're not harvesting information for resale?


How could you even imply such a thing?

Laughter OL.
 
2017-09-27 10:59:52 AM  
This could be useful for me.

I personally hate Google Sheets, and find it very limiting.  I have to deal with Google Sheet fanatics all day long, which increases my annoyance.

All hail our Excel Overlords.
 
2017-09-27 12:21:35 PM  
Are they bothering to fix the UI yet?
Nope? Don't care.


/fark snap scrolling
 
2017-09-27 01:24:53 PM  
Excel can already pull data from the internet.....

Set ie = CreateObject("InternetExplorer.Application")

endofnextmonth = DateSerial(Year(Date), Month(Date) + 2, 0)

With ie
.Visible = False
.navigate ("URL")
End With
While ie.ReadyState 4
DoEvents
Wend
ie.document.getelementsbyname("ReportViewerControl$ctl04$ctl11$ddValue​").Item.Value = 2
ie.document.getelementsbyname("ReportViewerControl$ctl04$ctl03$ddValue​").Item.Value = 1
ie.document.getelementsbyname("ReportViewerControl_ctl04_ctl07_cbNull"​).Item.Click
ie.document.getelementsbyname("ReportViewerControl$ctl04$ctl07$txtValu​e").Item.innertext = endofnextmonth
ie.document.getelementsbyname("ReportViewerControl$ctl04$ctl00").Item.​Click

I've removed comments and the URL because they reveal way too much about my employer...

And yeah my code sucks I'm not a programmer.
 
2017-09-27 01:58:11 PM  
"...Excel will soon be able to understand more about your inputs and then pull additional information from the internet as necessary paid ads from Bing all the farking time..."
 
2017-09-27 04:36:37 PM  
Oh FFS, Micro$oft, stop trying to be helpful.  I know what I am doing, and you do not.  Let's keep it that way.
/ Love Excel,
// HATE Word Formatting.
/// Powerpoint is even worse.
 
Displayed 32 of 32 comments

View Voting Results: Smartest and Funniest

This thread is closed to new comments.

Continue Farking

On Twitter





Top Commented
Javascript is required to view headlines in widget.
  1. Links are submitted by members of the Fark community.

  2. When community members submit a link, they also write a custom headline for the story.

  3. Other Farkers comment on the links. This is the number of comments. Click here to read them.

  4. Click here to submit a link.

Report