Jan 14, 2021

script editor does not show in google sheets/tools

script editor and macros do not show in google sheets/tools
Locked
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Recommended Answer
Jan 16, 2021
I actually just made a video showing the new apps script IDE, which is what you're seeing. As for the missing link in Tools, the link in Extensions takes you to the same place.

Macros are scripts. So if you're seeing any macro code, you are looking at the script editor. The only difference is that if any macros have been recorded, the macros.gs file becomes the default file, rather than the regular Code.gs. You can simply create a new file (the plus sign next to Files) and call it "Code.gs" or "Scripts.gs" or whatever you want.

Basically: You have access to everything, it just looks different

1 Video
Original Poster Gerald Wiles marked this as an answer
Helpful?
Recommended Answer
Jan 16, 2021
Thank you, Spencer! I think this new interface caught us all by surprise. Hopefully we can find out why it showed up.
 
Sorry for how long this took, Gerald, but glad it's working for you now. 
Original Poster Gerald Wiles marked this as an answer
Helpful?
All Replies (21)
Jan 14, 2021
Is the file you are opening a Google Sheet or a MS Excel file? I don't think the script editor is available for Excel files opened with Sheets at this time. If you aren't sure, you can look at the top of the screen. An Excel file will have an icon like this next to the document name:
You can save the file as a Sheets document from the File menu > Save as Google Sheets then use that new copy as your master file. 
 
I'm also going to move this thread to the Docs Editors forum where if this isn't the issue you should be able to get additional help. 
 
If this doesn't resolve the problem, please share a sample file per the best practices post so we can dig into this more. 
Jan 15, 2021
I can see the Script editor and Macro options in the Tools menu when I open it with my account (two of them even.)
 
I couldn't get a small sample script to work (I'm not much of a scripter though so that doesn't mean much) but I was able to get a macro working - it colors two cells red. Can you see that? You might need to give it permissions to run.
 
If that doesn't work, I think at this point we'll need to start doing some other troubleshooting. 
 
I suggest trying the general troubleshooting instructions provided in the Help Center. If we can reproduce the error we can escalate it so that it is more visible but without being able to reproduce the error it is hard to provide specific guidance. Besides, they'll ask us to have you do this first if we don't ask now. :)
 
In general the troubleshooting steps are:
  1. Refresh your page with the forced refresh option
  2. Try an incognito or private browsing window
  3. Try a different browser (Chrome instead of Safari or Firefox instead of Chrome, etc.)
  4. Turn off browser plug-ins and extensions (Chrome, Firefox, Edge, Safari)
  5. Clear your cache and cookies
  6. Turn offline settings off and on again
More detail for each of these steps is provided in the link above.
 
For display type issues, try disabling hardware acceleration for your browser:  TURN OFF Hardware acceleration
 
The incognito window / private browsing bit is really the most critical point to start with. Can you see the script editor when you do that?
Jan 15, 2021
I do not see any changes to spreadsheet. No red cells.
I did #1,  the forced refresh option, no change.
Did #3, I switched to Microsoft Edge Browser from Chrome, no change
Did #5, Clear cache and cookies, no change.
#6, was unable to turn offline setting off. Settings/Settings/Offline. Clicked on check mark but nothing happened, check mark stayed.

I'm using Chrome Browser, don't see how to turn off hardware acceleration
Jan 15, 2021
Thank you for your e-mail saying this:
I understand that you need assistance on getting the Script Editor to show up on Google Sheet
I'd like to set your expectation that I provide support for Google Drive, which handles issues with the Drive sync application, the Drive website and storage concerns.
You may refer to this article from Google Editors Help: Automate tasks in Google Sheets
Or else, please post your question on the Community Forum of Docs Editors Help for assistance. Our community of Google users are very knowledgeable about Google Sheets issues and are always happy to help.
Should you have any other questions about Google Drive, please feel free to reply to this email and I'll be glad to further help!

Your referral to an article from Google Editors Help is absurd as I would need the problem with Google Sheets fixed first.

Your second post to me showed a screen print of the exact problem. Script editor not in the Tools menu. Then 4 more suggestions from you and then I receive the above e-mail telling me to go somewhere else for assistance. 

Great!!! That was many hours wasted. Wouldn't it be customer service if you went somewhere else and got an expert in touch with me to fix the problem?
Jan 15, 2021
This is what a new Google Sheet shows in the Tools menu:

Jan 15, 2021
If your previous reply, you said you did #1 and #3, but you didn't report on #2 or #4. What shows when you are in a private browsing/incognito window?
 
Really, those steps are just abbreviated versions of and older version of the "general troubleshooting instructions" I had linked to. There is more detail in that link. 
 
Also, the macro I created just turns two cells red - I ran it then reset them to see if you could run the macro. I've highlight in pink the cells that should change when the macro is run. The macro is still working for me. It runs by going to Tools > Macros > Untitled macro. And I did need to authorize it to run when I did that.
 
In your last post you said you received an email, what/who was that email from? I've not seen that type of email before and certainly did not send that. 
 
My second post showed the exact problem that you are experiencing except that you say you are not using an Excel file. I was using an Excel file which is why it looks that way. That is completely expected if you are opening a non-native Google Sheet file and I have not ever seen it in a Google Sheet, that's why it is so hard to figure out. Also, your images still are not showing. Are you able to use the "Attach files" option for them? That is the best way to include images.
Jan 15, 2021
This is so frustrating!!!
You ask What shows when you are in a private browsing/incognito window?
How do I do that?

How can I run a macro when I can't get to the script editor? Yes the spreadsheet now shows red cells but I didn't run the macro.

I can not attach a file (PDF). This error message when I hit post. A problem occurred. Please try again

The e-mails are coming from Google Docs Editor Community. E-mails are the same as all our posts.
Jan 15, 2021
Hi Gerald,

I'm sending you an email, I'd like to help you resolve this issue, if possible.
Jan 15, 2021
Hello
Yes I received your post as an e-mail. I hope you can help. What is the next step?
Recommended Answer
Jan 16, 2021
I actually just made a video showing the new apps script IDE, which is what you're seeing. As for the missing link in Tools, the link in Extensions takes you to the same place.

Macros are scripts. So if you're seeing any macro code, you are looking at the script editor. The only difference is that if any macros have been recorded, the macros.gs file becomes the default file, rather than the regular Code.gs. You can simply create a new file (the plus sign next to Files) and call it "Code.gs" or "Scripts.gs" or whatever you want.

Basically: You have access to everything, it just looks different

1 Video
Original Poster Gerald Wiles marked this as an answer
Jan 16, 2021
Yes that answers my question. 
Thank you very much for your time.
Recommended Answer
Jan 16, 2021
Thank you, Spencer! I think this new interface caught us all by surprise. Hopefully we can find out why it showed up.
 
Sorry for how long this took, Gerald, but glad it's working for you now. 
Original Poster Gerald Wiles marked this as an answer
false
14043559677536936469
true
Search Help Center
true
true
true
true
true
35
false
false
Search
Clear search
Close search
Main menu