Is it possible to automatically update information on a Google Presentation or Document based on information in a Google spreadsheet?  For example, I could create a presentation that contains a graph based on data in a spreadsheet. As the spreadsheet is updated, the graph on the presentation is automatically updated.
120725
Is it possible to embed a Google Spreadsheet into a Google Document à la Microsoft Excel and Microsoft Word? How about a chart from a Spreadsheet?
101556
Background: I've been having some sleep issues so I have started tracking my sleep habits along with some other data but so far, they are just entries in Evernote and as such it is not possible to see any patterns. Obviously I need a spreadsheet app with charting capabilities (doh!). I've been using a great iPhone app called  for data collection for sleep times and then enter those into Evernote.  I have the iWork set so I have been looking at Numbers and going through some tutorials but I still can't tell if it will do what I want. Given that my data set will increase daily, I'd like to be able to "page through" a chart/data set, so it shows say the last 30 data entries. With all the tutorials I have seen, the charts are of fixed size and adding more data to a linked table just causes the chart to cram more stuff in.  Can Numbers do this sort of "paging" of data? I would like to have this sort of "on the fly" charting rather than having to explicitly build a chart each time I want to visualize the data.   (sorry the question is rather garbled: I don't know really anything about using a spreadsheet type app)
60649
I have an Excel file that want to update and save automatically with out having to open it or manually interact with.  Manually, I open the file up and hit data refresh which goes and does a SQL query and then hit F9 for the formulas to update and then I just close/save.    (I then would mail the file out to people using a perl script or use SAS JMP to run some numbers/charts and also mail them out.  Basically I need to script some things which require the XLS file to be updated.)
26218
I have a spreadsheet in Google Sheets that is shared with five people.  Only a few columns are edited; all of the other columns are locked.  We need the ability to track changes to these editable columns, so, , I added a script in Apps Script like this:  function onEdit() {  if( s.getName() == "MySpecialSheet" ) { //　Set to sheet name    var r = s.getActiveCell();    var col= r.getColumn();    if( col == 3 ) { // Check the column      var nextCell = r.offset(0, 1);       var datetime = new Date();      datetime = Utilities.formatDate(datetime, "GMT+9", "yyyy/MM/dd, hh:mm:ss"); // +9 for Tokyo      nextCell.setValue(datetime);    };  }; }   This automatically inserts the time when the relevant cell was edited, which is great.  However, I also want to add a way to tell who edited the cell.  I checked the  in the apps script documentation, but it seems the only method is getEmail(), which:     is not available in any context that allows a script to run without   that user's authorization, like a simple onOpen(e) or onEdit(e)   trigger, a custom function in Google Sheets, or a web app deployed to   "execute as me" (that is, authorized by the developer instead of the   user).   Since my script uses onEdit(), I have no way to get the email address.  Is there a way to get any kind of ID (I don't need the email address-- it could be the name of the account or a number) for the person editing a cell, and then insert that into another cell?  If not, I suppose I can create a column that people can just type their initials into, but people tend to forget so I would prefer an automated solution if possible.
19812
I've got a document that's convenient to keep in a spreadsheet because of calculations, but I also have a significant amount of text that I'd like to keep in the same place. Some of that text involves hyperlinks, preferably in line with plain text, but my attempts at figuring out how to write a formula that prints the output from HYPERLINK() next to plain text have all resulted in parsing errors.  The result I'm looking for is      plain text   So far I've tried  =HYPERLINK("http://google.com", "Google") + plain text =CONCATENATE(HYPERLINK("http://google.com", "Google"), plain text)   Google's documentation isn't leading me anywhere.
116355
In an Excel spreadsheet, I'd like to automatically update a cell with the current date and time when another cell is changed (like an update timestamp).  There is a timestamp for each row. I'd like to update them as soon as one of the preceding cells in the row is updated.  Do you have any pointers on how to do that?
28008
I would like to make graphs, pie charts, etc based on fields in my table within my infowindows. Is there a way to accomplish this?
51509
My page titles are dynamically created with PHP: I set my page title in my PHP functions, and when the function is triggered the title is set.  Is Google able to read the page titles?
44152
How can I get a user-defined function to re-evaluate itself based on changed data in the spreadsheet?  I tried F9 and Shift+F9.  The only thing that seems to work is editing the cell with the function call and then pressing Enter.
45097
I am running the Calculate Field GP tool from the arcpy in ArcMap. When a row value is updated, it does not show up untill I use the Reload Cache tool (Table Options > Reload Cache). How do I refresh the attribute table automatically without using ArcObjects?  I have tried updating the definition query as @blah238 suggested , but this doesn't help. Resetting the data source is not an option because the feature class might be in the editing session and I don't want to lose the connection to the source data.
86802
Years ago I figured out how to embed a spreadsheet in an Outlook email to automate a task I do regularly.  Whenever I want to send a new quote request I open an old email, tell Outlook I want to resend it, fill in the new values in my embedded spreadsheet and then send it off.  This method worked well for years.  After switching to a new computer however, I have found that when I open the latest emails I have sent, I cannot edit the embedded spreadsheet because Outlook interprets it now as a GIF.  Saved emails that I sent with the old computer however, still work fine - I can still open, edit and resend and Outlook interprets the embedded spreadsheet correctly.  I would like to figure out how to setup Outlook in the new PC correctly so that the embedded spreadsheet is interpreted correctly when the email is reopened. Some sort of security setting, maybe?  Any help anyone could provide would be appreciated.  Edit: I developed the spreadsheet originally in Excel. Then I went into Outlook, created a new email, did Insert->Object->Excel Spreadsheet. At that point I had a blank spreadsheet in my email. Then I copied and pasted the spreadsheet from Excel into the blank spreadsheet in Outlook and it worked perfectly (until this recent problem)
16040
I have seen  and altough I face the same problem, the answer to that question is not helpful to my case.   I have large spreadsheets which are changed frequently. So, according to the solution accepted to that question, it is hard to duplicate all populated columns and it is cumbersome to edit one more cell everytime I wish to make a change on cells background colors.  Isn't there a way to sum data based on a condition regarding cell background color in Google Spreadsheets?
92591
I want to be sure all my Google Spreadsheet work can be converted OK to Excel. How many of the Excel formulas match the formulas of Google spreadsheets?
31048
I'm using Google Spreadsheet's  function as a shortcut to insert the current timestamp now.   However, the value in the cell changes whenever the spreadsheet is modified in any way, even when the changes have nothing to do with that particular cell.  How do we stop the value in the cell from being automatically updated?
24371
This question specifically applies to Google Documents, not Google Spreadsheets (but if the answer applies to both, all the better).  Google Documents has built-in . I would like to define my own key binding or shortcut so that I can run a user-defined script on the document directly without using the mouse. For scripts that I want to run often, having a key binding or shortcut I can press saves me wasted motion from having to use the mouse to pull down a menu and run the script.  I have scoured the  and found no mention of allowing this level of customization.    Do I conclude that Google did not include this feature?  I have not investigated possibilities of using Firefox-specific extensions but that would be my next approach (e.g., ).  Note that this is not the same question as asked in  .
100963
I am using SharePoint 2007 + Windows Server 2008 with SharePoint 2007's publishing portal template. I am using List Web Part with Data Sheet view. I want to know how to make a column as a URL link (i.e. show text in the cell, and can associate a link with the text in each row for the specific column), i.e. when user clicks the text in the specific column of a specific row, the user will be directed to the link associated the text.
7668
Is there a way to do a particular task manually, generate the code for it automatically and update that code to do some task repeatedly?  I'm looking for something like record macro functionality that's available in MS Excel.