It doesn't work for me. When I select the trusted location I get "The remote or network path you have entered is not allowed by your current security settings."
Can you try this for network drives The solution is to re-map the network drive to the fileserver name first and then adding that mapped directory to the trusted locations in excel. Mapped Location: \\fileserver etworkdirectory and not \\[192.xxx.xxx.xxx] etworkdirectory
I’m not sure how to do this. Tried your solution and I had the same results as the person above, since the file is on a shared drive. How do I remap the network drive to the file server name? Do I need some special access to do that?
Can you try this for network path The solution is to re-map the network drive to the fileserver name first and then adding that mapped directory to the trusted locations in excel. Mapped Location: \\fileserver etworkdirectory and not \\[192.xxx.xxx.xxx] etworkdirectory
To customize the project dashboard please follow these steps. Click on the Settings button in Gantt menu, select the 'Project' tab and then click 'Unhide Dashboard supporting sheets" This will unhide two worksheets - Dashboard Data Worksheet (contains all the data from all projects) and the PivotSheet (contains all pivot tables). You can then use the data in the 'Dashboard Data Worksheet' to create additional graphs or pivot tables in the PivotSheet. Please do not delete any pivot tables/ pivot charts or data in the 'Pivot Data Sheet' or the 'Dashboard Data Worksheet' or the Project Dashboard worksheet. You can add new charts based on your project needs within the Project Dashboard worksheet.
To customize the project dashboard please follow these steps. Click on the Settings button in Gantt menu, select the 'Project' tab and then click 'Unhide Dashboard supporting sheets" This will unhide two worksheets - Dashboard Data Worksheet (contains all the data from all projects) and the PivotSheet (contains all pivot tables). You can then use the data in the 'Dashboard Data Worksheet' to create additional graphs or pivot tables in the PivotSheet. Please do not delete any pivot tables/ pivot charts or data in the 'Pivot Data Sheet' or the 'Dashboard Data Worksheet' or the Project Dashboard worksheet. You can add new charts based on your project needs within the Project Dashboard worksheet.
I tried this settings for my Excel in my office. It gives "MS VB for Application'" - "File Not Found" errors. Anyone encountered this and managed to resolve it?
The trusted location solution is the official way to use a macro enabled file. You will find more details in the link below from Microsoft. learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked
I looked for a solution for 30 minutes and your video helped me. Thanks
You are most welcome. We are glad you found it helpful.
Thank you so much for your hard work on the planner file, it's excellent!
Glad you like it!
It doesn't work for me. When I select the trusted location I get "The remote or network path you have entered is not allowed by your current security settings."
Can you try this for network drives
The solution is to re-map the network drive to the fileserver name first and then adding that mapped directory to the trusted locations in excel.
Mapped Location:
\\fileserver
etworkdirectory and not \\[192.xxx.xxx.xxx]
etworkdirectory
I’m not sure how to do this. Tried your solution and I had the same results as the person above, since the file is on a shared drive.
How do I remap the network drive to the file server name? Do I need some special access to do that?
Tried remapping the same, but still received the same response, can you suggest other ways?
@@GanttExcel
It's work only on local desk but how we can add the network path ?
Can you try this for network path
The solution is to re-map the network drive to the fileserver name first and then adding that mapped directory to the trusted locations in excel.
Mapped Location:
\\fileserver
etworkdirectory and not \\[192.xxx.xxx.xxx]
etworkdirectory
Thanks so much! You just saved me a lot of troubles!
You are most welcome. We are glad you found it helpful.
What about the chart Information , ( the chart that shows resume about your project ) I can't see videos , how we can customize ?
To customize the project dashboard please follow these steps.
Click on the Settings button in Gantt menu, select the 'Project' tab and then click 'Unhide Dashboard supporting sheets"
This will unhide two worksheets - Dashboard Data Worksheet (contains all the data from all projects) and the PivotSheet (contains all pivot tables).
You can then use the data in the 'Dashboard Data Worksheet' to create additional graphs or pivot tables in the PivotSheet.
Please do not delete any pivot tables/ pivot charts or data in the 'Pivot Data Sheet' or the 'Dashboard Data Worksheet' or the Project Dashboard worksheet.
You can add new charts based on your project needs within the Project Dashboard worksheet.
Could you explain us how we can make changes on the pivot chart ? I Bought your product
To customize the project dashboard please follow these steps.
Click on the Settings button in Gantt menu, select the 'Project' tab and then click 'Unhide Dashboard supporting sheets"
This will unhide two worksheets - Dashboard Data Worksheet (contains all the data from all projects) and the PivotSheet (contains all pivot tables).
You can then use the data in the 'Dashboard Data Worksheet' to create additional graphs or pivot tables in the PivotSheet. Please do not delete any pivot tables/ pivot charts or data in the 'Pivot Data Sheet' or the 'Dashboard Data Worksheet' or the Project Dashboard worksheet.
You can add new charts based on your project needs within the Project Dashboard worksheet.
I tried this settings for my Excel in my office. It gives "MS VB for Application'" - "File Not Found" errors. Anyone encountered this and managed to resolve it?
Sorry we haven't heard of this issue. You can check with Microsoft Support.
Thank u so much, it's really work on my excel.. 😊
You are most welcome. We are glad you found it helpful.
This doesn't work and neither unlocking the file, because there's no unlock option here.
The trusted location solution is the official way to use a macro enabled file. You will find more details in the link below from Microsoft.
learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked
such a simple yet effective video. Thank yoU!!!!!!!!!!!!!!!!!!!!!!!!!!!!
You are most welcome. We are glad you found it helpful.
thank you very much your video helped me very much
Glad it helped
Thanks! Gantt Excel 👏
You are most welcome.
Thank you so Much My issue has been resolved
You are most welcome. We are glad you found it helpful.
Thank you very much. This worked!
You are most welcome :)
Thank you. This worked!
You are most welcome. Glad it worked for you.
It's worked thank youu☺
You are most welcome. We are glad you found it helpful.
good job! thanks
You are most welcome.
Thank you very much.
You are most welcome.
great Video
Thanks!
Thank You
You are most welcome
Thank you
You're welcome