Groups | Search | Server Info | Login | Register
Groups > comp.apps.spreadsheets > #13
| Path | csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail |
|---|---|
| From | phil@groklabs.com |
| Newsgroups | comp.apps.spreadsheets |
| Subject | Re: Help needed with exporting data from Google Spreadsheets to Excel via dynamic link |
| Date | Thu, 19 Apr 2012 11:41:38 -0700 (PDT) |
| Organization | http://groups.google.com |
| Lines | 26 |
| Message-ID | <3116792.207.1334860898118.JavaMail.geo-discussion-forums@pboo1> (permalink) |
| References | <5356450.619.1334858367200.JavaMail.geo-discussion-forums@pbep2> |
| NNTP-Posting-Host | 199.188.193.7 |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=ISO-8859-1 |
| X-Trace | posting.google.com 1334860899 10516 127.0.0.1 (19 Apr 2012 18:41:39 GMT) |
| X-Complaints-To | groups-abuse@google.com |
| NNTP-Posting-Date | Thu, 19 Apr 2012 18:41:39 +0000 (UTC) |
| In-Reply-To | <5356450.619.1334858367200.JavaMail.geo-discussion-forums@pbep2> |
| Complaints-To | groups-abuse@google.com |
| Injection-Info | glegroupsg2000goo.googlegroups.com; posting-host=199.188.193.7; posting-account=vx41JQoAAAA9LoHj6UIa3OOHfns_NOH4 |
| User-Agent | G2/1.0 |
| X-Received-Bytes | 2655 |
| Xref | csiph.com comp.apps.spreadsheets:13 |
Show key headers only | View raw
On Thursday, April 19, 2012 10:59:27 AM UTC-7, Phil wrote: > Hello Everyone. > > Here is my scenario. > > I have a google docs spreadsheet that is changed regularly - every two days or so. I want to automatically export that data into excel - note here, automatically! > > I want my client to be able to open an Excel file and see updated data from my google spreadsheet. I am able to manually push the data to her via spreadsheets, but I want it to happen automatically. > > I know that I can export a file (HTML, CSV, EXCEL, TXT) but that is not automatic. > > I know also, that I can publish to the web, and get a link to the published data. I have made sure to make that public data and everyone can access it. > > PROBLEM: When I try to open the URL (txt or csv) that Google Spreadsheets gives me in Excel 2011 (File, Open URL) > https://docs.google.com/spreadsheet/pub?key=0Aqr4T7rLB9FMdDZ2S1daa3RIeFNMdWVKck9FNWF6YVE&single=true&gid=0&output=csv > > I get the following message: This site cannot be accessed. And Microsoft Excel cannot access the file "Filename" > Path does not exist > its being used by another program > name of the workbook is the same as another already open. > > This is not the case in any of the examples. > > Can anyone help with this solution or any other solution that will allow me to automatically update data from google spreadsheets into Excel. Found the answer - I am using Excel 2011 for Mac - which does not allow you to do this. Crazy pointless laziness from Redmond.
Back to comp.apps.spreadsheets | Previous | Next — Previous in thread | Next in thread | Find similar
Help needed with exporting data from Google Spreadsheets to Excel via dynamic link Phil <phil@groklabs.com> - 2012-04-19 10:59 -0700
Re: Help needed with exporting data from Google Spreadsheets to Excel via dynamic link phil@groklabs.com - 2012-04-19 11:41 -0700
Re: Help needed with exporting data from Google Spreadsheets to Excel via dynamic link Peter Grummett <peter.grummett@regather.net> - 2012-05-27 00:34 -0700
csiph-web