3 ms·
Here are some links that may help solve your problems. Comparing spreadsheets is standard since Excel 2013. https://support.office.com/en-us/article/compare-t
by p33p 8y ago
Here are some links that may help solve your problems.
Comparing spreadsheets is standard since Excel 2013.
https://support.office.com/en-us/article/compare-two-versions-of-a-workbook-by-using-spreadsheet-compare-0e1627fd-ce14-4c33-9ab1-8ea82c6a5a7e https://support.office.com/en-us/article/compare-two-version...
Power Query may be of use to automate ETL type processes, which is standard since Excel 2016 and is a free add-on prior:
https://support.office.com/en-us/article/introduction-to-microsoft-power-query-for-excel-6e92e2f4-2079-4e1f-bad5-89f6269cd605 https://support.office.com/en-us/article/introduction-to-mic...
- Adamantcheese 8y agoThose would be great solutions but we're stuck on Excel 2007 and can't install any newer versions or basically any software because of IT reasons.
- WorldMaker 8y agoOffice 2007 hasn't even been Extended Supported for two years now. That seems an egregious information security problem and your IT may need at least some modest sanity checks. https://support.microsoft.com/en-us/help/3198497/office-2007-approaching-end-of-extended-support https://support.microsoft.com/en-us/help/3198497/office-2007...