Enter Website Address into Excel Spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-3084221%22%20slang%3D%22en-US%22%3EEnter%20Website%20Address%20into%20Excel%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3084221%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20usernames%20and%20passwords%20for%20websites%20I%20frequent%20often.%20I%20want%20to%20add%20a%20column%20to%20this%20spreadsheet%20and%20copy%20website%20addresses%20(URLs)%20into%20a%20new%20column.%20I%20have%20tried%20using%20the%20hyperlink%20function%2C%20but%20I%20keep%20getting%20this%20error%20message%3A%20Your%20organization's%20policies%20are%20preventing%20us%20from%20completing%20this%20action%20for%20you.%20For%20more%20info%2C%20please%20contact%20your%20help%20desk.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20my%20personal%20computer.%20I%20do%20have%20admin%20rights%20to%20make%20any%20kind%20of%20changes%20I%20want.%20Chrome%20is%20up%20to%20date%20and%20running%26nbsp%3BVersion%2097.0.4692.99%20(Official%20Build)%20(64-bit).%20I%20am%20using%20a%20Chrome%20browser%2C%20but%20I%20also%20have%20access%20to%20Microsoft%20Edge.%20I%20am%20running%20Microsoft%20Office%20Home%20and%20Student%202013%2C%20Version%2015.0.5415.1001%2C%20Product%20ID%2000197-19025-15254-AA427%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20tell%20what%20I%20need%20to%20do%20to%20add%20this%20functionality%20to%20my%20spreadsheet.%20Thank%20you%20very%20much.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3084221%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3085197%22%20slang%3D%22en-US%22%3ERe%3A%20Enter%20Website%20Address%20into%20Excel%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3085197%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1290594%22%20target%3D%22_blank%22%3E%40GoldieGold3223%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EMaybe%20this%20approach%2Flink%20will%20help%20you%20further%20in%20your%20plans.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-an-external-reference-link-to-a-cell-range-in-another-workbook-c98d1803-dd75-4668-ac6a-d7cca2a9b95f%23ID0EBH%3DWindows%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ECreate%20an%20external%20reference%20(link)%20to%20a%20cell%20range%20in%20another%20workbook%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20Link.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%3CFONT%20color%3D%22%230000FF%22%3E%3CSTRONG%3EWas%20the%20answer%20useful%3F%3C%2FSTRONG%3E%3C%2FFONT%3E%3CFONT%20color%3D%22%23DF0000%22%3E%3CSTRONG%3E%20Mark%20them%20as%20helpful!%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%20color%3D%22%23008000%22%3E%3CSTRONG%3EThis%20will%20help%20all%20forum%20participants.%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a spreadsheet with usernames and passwords for websites I frequent often. I want to add a column to this spreadsheet and copy website addresses (URLs) into a new column. I have tried using the hyperlink function, but I keep getting this error message: Your organization's policies are preventing us from completing this action for you. For more info, please contact your help desk.

 

This is my personal computer. I do have admin rights to make any kind of changes I want. Chrome is up to date and running Version 97.0.4692.99 (Official Build) (64-bit). I am using a Chrome browser, but I also have access to Microsoft Edge. I am running Microsoft Office Home and Student 2013, Version 15.0.5415.1001, Product ID 00197-19025-15254-AA427

 

Can someone please tell what I need to do to add this functionality to my spreadsheet. Thank you very much.

 

1 Reply

@GoldieGold3223 

Maybe this approach/link will help you further in your plans.

Create an external reference (link) to a cell range in another workbook

 

Hope I was able to help you with this Link.

 

NikolinoDE

I know I don't know anything (Socrates)

Was the answer useful? Mark them as helpful!

This will help all forum participants.