Forum Discussion
Excel Remove Message and auto fill the year
Select File > Info.
On the right hand side, you should see 'Edit Links to Files'.
Click on this link.
In the 'Edit Links' dialog, click 'Startup Prompt...'
Choose the second or third option, according to your preference.
Click OK.
Here is some of what is on the right side of the page
Status - categories -hyperlink Base - Related Documents - tags - template
on the left side there are 2 boxes that are highlighted yellow:
Security Information - active content might contain malware and other security hazards. The active content in this file is allowed to run because it is a Trusted Document, and policies or trust center setting aren't restricting it.
Trust center Settings
Learn more about active content
Learn more about trusted documents
I don't know if I need to go into one of the topics above.
Please advise
I'm afraid I cannot help you without seeing (a copy of) the workbook. Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
- I must have been over tired and looked in a worksheet that didn't have the copy paste with the link. I came in this morning and checked all of the files and found the "Edit Links to Files" and made the changes you showed me.
I will see if that works today I have several more reports to create with that Link.
Thanks for all of your help and again sorry about the mistake.
BillI am doing the copy paste (using: Paste Link (N). After I complete the paste I protect the sheet. Under the protection options I have none of the boxes checked. I don't know if I am suppose to have something checked.
When I go back in and reopen the worksheet I get two warnings (I have attached them for your review). I would like to know how I can get rid of these two warnings like you helped me with earlier. I tried to look in the "Edit Links to files" (I have the last one checked "don't show the warning but do the update".
Is there anything I can do to get rid of the warning signs. Once I click ok the link still works the way it is supposed to.