Opening an Excel spreadsheet or Access database file containing macros on a Windows computer
Running macros in Excel or Access files downloaded from the internet is disabled for security reasons. However, it is possible to run macros when the file is opened from a trusted location.
Browsers typically save files to the user's Downloads folder, which is not a trusted location. When attempting to open a file from an untrusted location, a message with pink background text will appear indicating that macros have been disabled.
The trusted locations at Metropolia include:
- U network drive with its subfolders
- P network drive with its subfolders
- Personal network drive "Z" with its subfolders
- Documents folder with its subfolders located in the user's profile (C:\Users\username\Documents)
Move the file to a trusted location and open it from there.
Did You Encounter a Problem?
- Restart your computer and the device where the issue is occurring. Try the function again.
- If the function you are attempting is happening in a web browser, try the function again in an incognito or private window and in a different browser.
- Try searching for a solution on the site of the IT Services by using the following search methods:
- navigation menu of the site (on the left)
- search machine of the wiki (right upper corner)
- a general search engine, for instance Google Search
- alphabetical index
- FAQ
If the problem is not resolved, please contact the helpdesk according to best practices. Always include a full screen screenshot of the issue in your service request.
| Contact method | Contact information |
|---|---|
| Ask AI-Bot Mikko 24/7 | |
| Form | |
| Phone service | +358 9 7424 6777 (weekdays from 8 am to 4 pm) |