Groups | Search | Server Info | Login | Register

Groups > comp.apps.spreadsheets > #14

Re: Help needed with exporting data from Google Spreadsheets to Excel via dynamic link

Show all headers | View raw

On Apr 19, 7:41 pm, p...@groklabs.com wrote:
> 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=0Aqr4T7rLB9FMdDZ2S1daa3RI...
>
> > 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.

Hi Phil - Have you found a way of doing this yet? This is exactly what
I need but haven't had any luck yet?

Back to comp.apps.spreadsheets | Previous | Next — Previous in thread | Find similar

Thread

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