via
Popular answer by ahab
luxtitan,
I theory there is a way to reset the number of submits used by the summary back to 0, but you should first test it on a copy
of your spreadsheet!
of your spreadsheet!
Very Important! Make sure when doing so the sheet the submits should go to is the leftmost of your sheets!
So use the following steps:
0) Move the sheet that should receive the form submits to the far left of your sheets, select this sheet and go to the Form tab.
Important: Should you omit this step the form may become reconnected to the wrong sheet!
1) Open the form editor, this will show the current form. Leave the form editor open!
2) Go back to the spreadheet and delete the form (Form->Delete form), wait a little bit and check in the spreadsheet the form menu item now reads plain Form , i.e without any counter after Form.
3) Go back to the form editor which you left open, edit one of the questions, but make no changes to it, just click Done.
4) Still in the Form editor, click on Save; in the spreadsheet on the Form menu check it says now Form (0).
2) Go back to the spreadheet and delete the form (Form->Delete form), wait a little bit and check in the spreadsheet the form menu item now reads plain Form , i.e without any counter after Form.
3) Go back to the form editor which you left open, edit one of the questions, but make no changes to it, just click Done.
4) Still in the Form editor, click on Save; in the spreadsheet on the Form menu check it says now Form (0).
5) Close the Form editor
This is an unofficial workaround and you should use it at your own risk and always try and test the method on a copy of your spreadsheet; I tried this and got it working in IE6 Win XP, but other browsers / versions / operation systems may give a different result.
Note: the above method may also be used the make the form reassociate to the sheet; as a result the questions and the headers in the submits receiving sheet will have the same order and they way the submits go to the columns will be re-eastablised; questions submitted by the form should now go to the appropriate columns as indicated by the headers.
IMHO the Google Docs spreadsheets team should make this an option in the Form menu; if possible without the need to make the submits receiving sheet the leftmost one in the spreadsheet while doing the reset.
Quicken has several support options to suit your needs. Before contacting support, we recommend that you check to see if you have the latest release of your Quicken product installed. Updating your software with a free patch is the fastest and easiest way to ensure that your Quicken is working properly.
ReplyDeleteQuicken Support