Published By:
42.7K

Google released Google Drive on April 24, 2012. While you may already have Microsoft Word, Excel, PowerPoint or other Microsoft products, using Google Drive has its own benefits. One of the biggest benefits is that you can use tools other Google Drive users have created.

Generally speaking, when you want to download one of these tools (often created in a spreadsheet), the user sharing the tool will make the document public so everyone can view but protect (or lock) the sheet so that no one can edit. This is intentional. Here are a few indicators that the sheet is locked or protected:

Protected sheet indicators:

1) Menu items are greyed out.

 

2) Ranges are greyed out (like A2 below):

 

3) Worksheets show a lock icon:

 

But there’s good news for you: with just a few simple steps, you can access the tool.

 

Steps to unlock the tool:

1) Make a copy of the file. Click File >> Make a copy…

 

2) Name the copied document.

 

3) Once you’ve made a copy of the file, the copy will open in a new tab. You’ll need to refresh the page in your browser, then your menus will be available. Ranges will be unlocked and worksheets will not display a lock icon.

 

4) In this example, a non-standard menu is available, the Page Speed Menu.

 

When selecting any item from a non-standard menu, you will need to grant the app authorization to run. Click OK.

 

5) You will see a dialog like this one. Click Accept to proceed:

 

7) Once you click ‘Accept’, the selected item will not execute until you click it one more time. Click your menu item again.

 

Document Unlocked

You’re done! And the tool you’re using will work its unlocked magic from here.

revcontent-98%-of-sites-get-denied-are-you-in-the-2%
42.7K

Sponsored Resources

Want more resources

View all Resources




Most Read

Contributors

Our publication contributors combine decades of experience with unique insights into the content promotion and distribution industry.
Chad Pollitt Partner, VP of Audience Native Advertising Institute
Jay Baer Marketing Strategist, Speaker and Author
Gini Dietrich CEO Arment Dietrich
Jason Falls Social Media & Public Relations Thought Leader
Joe Beccalori CEO Interact Marketing
Douglas Karr Founder & CEO MarTech.zone & DK New Media
Brianne Carlon Rush Content Director Kuno Creative
Janine Popick Co-founder & CMO Dasheroo
Arnie Kuenn CEO Vertical Measures
Pam Didner Global Content Marketing Strategist & Author
Chirag Ahuja Head of Marketing WorkflowMax
Jayson DeMers Founder & CEO AudienceBloom
Erik Deckers Professional Writer Pro Blog Service
Bernie Borges CEO Find and Convert
Jessica Stephenson VP Marketing ExactHire
Michael Ferrari Marketing Consultant Pen Cap Online Marketing
Larry Alton Freelance Writer and Editor
David Tile Founder & Director Nimble Media
Kelsey Libert Marketing VP & Partner Frac.tl
Dan Steiner Co-Founder & CEO Elite Legal Marketing
Joydeep Bhattacharya Relevance Contributor SEOsandwitch.com
Jonah Bliss Founder CMO ContentIntent
Andrea Lehr Promotions Supervisor Fractl
Fernando Labastida Co-Founder Content Propulsion
Dan Moyle Creative Dir. Marketing AmeriFirst
Dennis Yu Chief Technology Officer BlitzMetrics
Arnaud Roy VP Marketing Augure
John Rugh Copywriter/Content Marketing Specialist
Justin Spicer Content Researcher, Producer & Editor
Michael Becker Marketing Support Spec. Teradata
Anna Johansson Freelance Writer
Amanda DiSilvestro Content Editor and Writer HigherVisibility
Sujay Maheshwari Founder & CEO Netcurate.com
Kelly Coulter Online Marketing Strategist
Taylor Radey Senior Consultant PR 20/20
Rodger Johnson Public Relations Leader & Consultant
Simon Penson Founder & Managing Dir. Zazzle Media
Danielle Wolter Nolan Co-Owner
Fernando Cuscuela Founder & CEO Everypost
Kelly Smith Content Manager CourseFinder
John McTigue EVP Kuno Creative
Yogita Arora Content Strategist Zoomph
Jordan Teicher Associate Editor Contently
Jonathan Crowl Digital Marketing Writer & Editor
Brian Honigman Marketing Consultant, Writer & Professional Speaker Skyword
Katherine Halek Content Strategist Signazon.com
Amanda Drinker Dooley Community Product Marketing Manager Netline
Anton Rius Digital Marketing Consultant More Than Metrics
Matthew Zajechowski Outreach Manager Digital Third Coast
Kevin Bailey Co-founder DigitalRelevance
Peter Chen Digital Marketing Consultant DigitalRelevance
Luana Spinetti Multi-Specialized Freelancer
Kyle Harper Writer Skyword
Elad Natanson Founder appnext
Maël Roth Content & Inbound Marketer Park7
Quin Woodward Pu Marketing Director Audienti
Greg Shuey Co-Founder Stryde
Jean Bansemer CEO My Web Writers
Owen Andrew Journalist
Luke Kintigh Global Content & Media Strategist Intel

In case you missed

Read more of the latest news and insights from thought leaders in content promotion and distribution.

Subscribe


Get the latest content promotion news and insights everyday.

Champion Sponsor

Relevance is proud to present our Champion Sponsor that helps make our site possible.

Cision Logo

© 2017 Relevance | Content Promotion News & Insights

Connect with RELEVANCE

Thank you for subscribing Your subscription has been confirmed.