I'm struggling to work on a custom functions Office JS addin because Desktop Excel keeps using old copies of the files. (I am, of course, stuck working on a Desktop-specific bug.)
I've cleared
%LOCALAPPDATA%\Microsoft\Office\16.0\Wef.I've cleared browser cache (though Excel is using slightly different version of Edge than my browser version, v100 instead of v99).
How do I get Desktop Excel to reliably load up-to-date files?
To give you an idea, I've done this sequence repeatedly:
Change
main.htmlto have an observable side effect (requesting a server resource with name "A" for instance).Eventually got to the point where Excel was using that version of the file.
Changed the file to show a different side effect (requesting "A2" instead).
Closed Excel
Cleared
WefCleared browser cache (though again, not clear it's the same one)
Ran the addin
Saw it run the old file
Opened devtools (this addin has a taskpane, so right-click and choose Inspect)
Do
fetch("/main.html").then(r => r.text()).then(console.log)and see the updated version ofmain.html(so, if it's browser cache, it's been updated)Close Excel
Stop and restart the web server (to clear its cache; it's really basic, only has memory cache)
Open Excel, run the addin, and still see the old side-effect (even though the web server shows a get for
main.html)Repeating the
fetchthing gets the latest version; not a browser or server caching issue. It's Excel itself.
This seems really basic and fundamental: Load the latest version of the resource. What am I missing?
Thanks,
-- T.J.