Directions to Update Group Order spreadsheet
. download form file from : https://newyorkna.org/information/tech/
. note this is an .xltx file
. open with excel
. go to file>permissions>unprotect
. enter password for spreadsheet (tBkiyNCBckC2wjNsKCXaDxqv)
. make edits (google and use “how to edit xltx file” as needed)
. save file using “file>save as”. Recommend incrementing file name
. use file type of .xltx (VERY IMPORTANT)
. Login to website
. go to dashboard>media>add new
. drag new xltx file into Upload window
. click on resulting smaller icon under Upload window
. copy portion of address from wp-content…, example:
wp-content/uploads/2020/12/GNYRSO-Group-Area-Region-Order-Form6.xltx
. Go to https://newyorkna.org/information/tech/
. click “edit” near bottom
. find the xltx file url in page
. replace string starting with wp-content with string you copied
. click “update” on right of page
. test: go back to page and download .xltx file and verify it works