Issue
I have run the Fund Transfer Data Report, open Excel Loader and there is no data in the loaders. Why?
I received an Excel Loader from the previous accountant. When I open it, there is no data in the loaders. Why?
Cause
This usually happens when the Fund Transfer Data, a zip file, has not been saved to the local drive, the security is not unblocked and unzipped.
Resolution
- Obtain the original Zipped file Fund Transfer Data
- Ensure it is saved to your local drive
- Right-click on the File > Properties > Click Unblock in the Security section > Apply > Ok
- Right-click on the Zip File > Choose "Extract All"
- Choose the folder to store the unzipped file and click on Extract(You must unzip the data file you received before you attempt to open the excel loaders)
- An unzipped folder with the same name will be created
- Open the Unzipped folder
- Open the Excel Loader within this folder.
- Once the Excel is open, click "Enable Editing" and "Enable Macro". Data will start populating into the Excel Loader.