💻 Software
Two large, linked Excel files take 30 minutes to save, except in VMWare environment
Fresh5 days ago
Mar 15, 20262082 viewsConfidence Score0%
0%
Problem
I support some tax consultants who love to use Excel when they should probably be using Access. Anyway, they have created two Excel files, A and B. File B has cells linked to file A. File A is 27 MB and file B is 16 MB. One worksheet has roughly 1 million rows and there is another worksheet doing a…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Two large, linked Excel files take 30 minutes to save, except in VMWare environment
Low Risk
I suggest unchecking the "Save External Link Values" option under: Excel Options -> Advanced -> When Calculating This Workbook: I think that this should solve your problem. Also doing some research on this topic pointed out to me that this problem o…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix