microsoft / python-in-excel

Python in Microsoft Excel
MIT License
517 stars 34 forks source link

Save failed error. #41

Open Auubinno opened 11 months ago

Auubinno commented 11 months ago

Hi, I'm trying to use the excel lab python editor to do simple calculations but I'm facing an error. Excel is reporting the following message:

Portuguese: "Save failed: O argumento é inválido, está ausente ou tem um formato incorreto." English: "Save failed: The argument is invalid, missing, or in the incorrect format."

The code I'm trying to run is the one bellow.

x=10 y=5 x+y

The erro show up when I press 'enter+ctrl' or when I try to save to convert to excel values.

The interesting part is that with the office insider program, I'm able to run the 'PY' function and get the 'x+y' value. My operating system is up-to-date, and the office suite has been recently updated.

firmacon commented 11 months ago

I have the same problem and my Excel is also in the Portuguese-BR version.

keyur32 commented 11 months ago

Same as issue #31. Will keep this active for now, and update when fixed.

keyur32 commented 11 months ago

Hi folks, this should be fixed in version 17106. Please let us know if this is still happening.

firmacon commented 9 months ago

image Yes, this is still happening...

firmacon commented 9 months ago

=_xlfn._xlws.PY(6;0;Workings!C3) It doesn't recognize python formulas... image

pedoandrade commented 9 months ago

Hi, I’m using the latest version but the error keeps appearing, even in the English version.

error

alcebiadesaraujojunior commented 7 months ago

Same problem.

apuntigam commented 2 months ago

Same problem here, I see it's been 5 months since this was last commented on...

LoreBadTime commented 2 months ago

Same error here

keyur32 commented 2 months ago

Hi folks, a few questions -- what channel are you folks on? If you are on Insiders Beta, can please see if it repros with the built in Python Editor? That will eventually replace the Excel Labs add-in.

https://techcommunity.microsoft.com/t5/excel-blog/graduating-the-python-editor-to-insiders-beta/ba-p/4185867

Also does it work when you manually enter the formula? Is the bug specific to the localize version?