Hey! I've had this before in a template that was previously running perfecting and it turned out I had somehow made a bunch of extra rows active, i.e. even though I was using let's say 100 rows, the template had the last row as like one million. I was getting a pop-up warning when I clicked save but it didn't really register with me. This was thankfully an easy fix. I just had to delete the non-active rows/columns so the scroll bar was back to the expected size (this also should have been the tell-tale sign to me that something was wrong).
Other things that can slow down a template:
- Extremely complex nested formulas - there would have to be a lot of them for it to be impactful
- Custom refresh (this might come into play where you have multiple section or block mappings and you ask vena to do them in a unique order, or double refresh)
- Bringing in more data than needed (e.g. bringing in 5 years of prior year GL data when you normally hide the prior 3 years anyway) - again, there would need to be a lot for it to be impactful
- Then the generic issue of computer speed. I believe the recommended RAM is 16GB and 8GB is the minimum
My fingers are crossed for you that it's the first, easiest issue!
------------------------------
Olivia MacDonald
Manager, Financial Systems and Operations
PwC
------------------------------
Original Message:
Sent: 10-03-2022 23:37
From: Mar James
Subject: Vena speed and freezing issues
Has anyone had issues with Vena Freezing Excel, or loading very slowly (6-8 minutes to load) or other connection type issues, and if so, how have you solved them?
We are having issues and can not resolve loading and using Vena.
------------------------------
Mar James
Systems and Software Specialist
Highfield Investment Group Inc.
Calgary AB
------------------------------