When using the Excel Add-in to import data into a dataset, you may encounter an unresponsive window, which can prevent the completion of the task.
Excel Desktop version
To resolve this issue, you will need to clear the Wef folder.
Close all Excel files and other Office programs.
On your keyboard, press Windows key + R to open the Run command prompt.
Copy and paste the following command: %LOCALAPPDATA%\Microsoft\Office\16.0\Wef\ then press OK.
File Explorer will display the Wef folder. Please delete all contents within the Wef folder.
Open Excel and proceed to prepare the journal again.
Note: Microsoft Office will re-create what it needs when the Add-in is next launched.
Note: The files in the Wef folder enable Excel to launch the add-in more quickly by preventing repeated downloads. However, if these files become outdated or corrupted, clearing this folder prompts Excel to retrieve a fresh copy, effectively resolving many Add-in related issues.
Excel Online version
Clear your browser cache or use private/incognito mode.
Clear the Cache in Chrome
On your computer, open Chrome.
At the top right, click the three dot icon.
Click More tools and then Clear browsing data.
At the top, choose a time range. To delete everything, select All time.
Next to "Cookies and other site data" and "Cached images and files," check the boxes.
Click Clear data.
Clear the Cache in Edge
On your computer, open Edge.
At the top right, click the three dot icon.
Click on Settings, and then Privacy, search and services.
Under Clear browsing data, click on Choose what to clear.
Choose All time range from the Time range drop-down menu.
Choose the types of data you want to clear, for example, you may want to remove browsing history and cookies but keep passwords and form fill data.
Finally click on Clear now.