Microsoft has blocked macros from running because the source of this file is untrusted

Microsoft has blocked macros from running because the source of this file is untrusted

Are you having issues editing Excel files that contain Macros and are stored on a network location?

We have been experiencing these issues too. For most of our stations we could just add the Network locationas a trusted path. But this has started to fail at least on some workstations.

We also tried adding the location under “Internet Options” which worked on some stations until recently. It now requires an https:// address which will not work for a share that just has an IP.

After losts of trial and error we decided to create Symbolic links on those stations to bypass the warning.

What Are Symbolic Links?

Symbolic links are basically advanced shortcuts. Create a symbolic link to an individual file or folder, and that link will appear to be the same as the file or folder to Windows — even though it’s just a link pointing at the file or folder.

So you can have a pointer lets say:

That points to a network location:

The folder will look like a regular shortcut:

All its doing is pointing to the location on the server/nas.

When you open a file from this location. Excel “thinks” its a local file and you will not get the dreaded red warning:


Example with syntax

Let say you’re trying to access files on; “\\server1\Share1\ExcelFiles” we can create a link on your desktop that will be named “ExcelFiles”.

Start a command window with Administrator privileges type the following command but edit the paths to match your environment:

Thats it! now you can open any file from that link without the limmiting macro issue.

This will probably be disabled at some point. Microsoft has been trying to disable macros for a while now. But at least this can buy us some time until we move away from using them.

 Let us know if this has helped you.



OneDrive app using too much memory (RAM)?

OneDrive app using too much memory (RAM)?

Are you having issues with slow syncs when updating OneDrive shares? Is your OneDrive client taking massive amounts of memory?

We had this very issue. When we checked-in with Microsoft Support they really didn’t have much of an answer, or helpful response / fix.
After checking all our OneDrive clients we noticed that they were using lots of RAM.

As you can see our Windows stations were using around 2.1GB and out Macs around the same. Some users that had more shares on OneDrive were using 2.7GB!!!

After testing different versions of the client. We checked the amount of files on our shares and found that we had over 400k. These were mostly small java or other code that we kept for each of our projects. We always try to keep backups of the old client projects/environments. This was never an issue when we had on-premise network shares. But when we migrated to the cloud issues started to appear. Usually slow syncs, or crashing of office files used in collaboration such as Excel files.

While trouble shooting the issue we removed one of the shares. This brought down the amount of files being synced. It took the office about a day for OneDrive to re-sync. But after that it started to use around ~600MB of RAM. Which is still a lot. But we felt the performance improve.

We hope this helps other folks having similar problems. 


GPD WinMax 2 Mini laptop for BIM work

GPD WinMax 2 Mini laptop for BIM work

GPD Win Max 2

Ultra Portable for field use
Training CalendarCourse Listing

We’ve all used large Laptop Workstations. These behemoths while capable to run CAD/BIM software turn out not to be the best for portable work. Mainly due to their size/weight and battery life. Sometimes we need a light alternative that can be used on the go. Over the years I’ve used smaller notebooks, ultrabooks. Usually 14″ or 13″ laptops that have a good balance of performance and battery life. In this category I’ve owned Dell’s XPS 13″, or LG Gram 14″, iPads, and Chromebooks.  All are lightweight but each has their own deficiencies. The Windows PC’s will trade performance for battery life. The iOS/Android options will need to remote into the office to run CAD/BIM software which can slow things down specially over slow connections.

The GPD Win Max 2 is a small form factor laptop designed for portability and performance, and it offers a number of benefits for users who need a powerful and portable device. Here are some of the pros of the GPD Win Max 2 for portability and performance:

    1. Small form factor: The GPD Win Max 2 is a compact laptop that can easily fit into a bag or backpack, making it ideal for people who are always on the go. It weighs just 790g, making it one of the lightest and most portable gaming laptops on the market.
    2. High performance: Despite its small size, the GPD Win Max 2 offers impressive performance thanks to its powerful AMD Ryzen 7 4800U processor and Radeon Vega 8 graphics. It can be purchased with 32GB of RAM and 1TB M2 SSD. This allows it to handle demanding applications and games with ease.
    3. Long battery life: The GPD Win Max 2 features a large 57Wh battery that can last up to 8 hours on a single charge, making it ideal for long flights or commutes.
    4. Plenty of ports: Despite its small size, the GPD Win Max 2 has a variety of ports, including USB-C, USB-A, HDMI, and Ethernet, which makes it easy to connect to external displays, peripherals, and networks.

Overall, the GPD Win Max 2 is a great option for anyone who needs a powerful and portable laptop. It offers high performance, long battery life, and a variety of ports, all in a small and lightweight package.

In the gallery below you can compare the Win Max 2 Size to a 14″ MBP. Its roughly 1/2 the size!

One very nice feature is that you can pick the Thermal Design Power (TDP) in watts, and refers to the power consumption under the maximum theoretical load.

So if you’re responding to emails or just web browsing you can select a very low value such as 5w. This increases the battery life of the system.

Send us a message or just call us at 201-792-6300

Lets Connect

Layout Tab Menu

Layout Tab Menu

File Tab Menu

File Tab Menu