Filehost.ro - gazduire fisiere
Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
Nou pe simpatie:
Laura_libero pe Simpatie.ro
Femeie
24 ani
Timis
cauta Barbat
32 - 50 ani
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides /

[EXCEL] Disable "You're Pasting Active Content" wh Pasting in Formulas

Pagini: 1 Moderat de TRaP, TonyTzu
pus acum 1 luna#1
TRaP
Moderator
Postari: 960
I had a few formulas referencing other files. I changed the name of those files, and wanted to update the formulas by pasting the new names.



To disable this:

- go to File > Options > Trust Center > Trust Center Settings... button
- on the left menu, select External Content.
- under Security settings for Workbook Links, select Enable automatic update for all Workbook Links (not recommended)
- click OK and OK again to save


 
   
Pagini: 1  
Mergi la