Hello, how to fix this problem in VBA - the excel files downloaded from JDE wouldn't calculate (no formula error, no ', no space before =, show formula off, not in text format), so far the only way I could fix it is to copy a cell from any normal excel sheet over, nothing working including ctrl+Alt+F9.
thanks in advance
Try Ctrl+~ (Control and tilde).
Artik
show formula is not the issue here...
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
the issue seems to have gone away, I wonder if Uipath messed up excel, I'm a RPA developer and my bot calls macros in excel. If I encounter this again in the future, I'll for sure attach the file while the problem remains. Thanks for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks