Cannot save a .xlsm file.
When I try to save a Excle file with macros (.xlsm) with OnePlaceDocs v7, I get a message that VB project cannot be saved to an .xlsx and will be lost.
I have the option to say yes to continue and lose code or no to change the file type. If I press no, nothing happens.
How can I save an .xlsm to SharePoint?
Thanks
-
Elissa commented
Hi Olivia
Great :) Thank you for the update!
Kind regards
Elissa
-
Olivia Kwant commented
Hi Elissa,
We've just downloaded 7.3 and the box in your screenshot has come up now so thank you :)
-
Elissa commented
Hi Olivia
I am not 100% sure what version of OnePlaceDocs you are now using.
When you save a new workbook in Excel, using OnePlaceDocs, do you have the following option:
https://d2r1vs3d9006ap.cloudfront.net/s3_images/1405663/xlsm.jpg?1461730611
Kind regards
Elissa
-
Olivia Kwant commented
Hi Elissa, we have had the same issues. Does the new fix come with the latest update? Just wondering because I have not seen this option before.
I was just about to put this in as an error, but see that it has already come up:
"A staff member opened an existing Excel file (xlsm) out of our SharePoint environment, they went to do a Save As into another SharePoint location and got this message:
"The following features cannot be saved in macro-free workbooks: VB Project. To save a file with these features, click No, and then choose a macro-enabled file type in the File Type list. To continue saving as a macro-free workbook, click Yes"
Can Excel files with macros (xlsm) not be saved into SharePoint using the Save to SharePoint button that comes with OnePlace Docs? Or is there a setting we can change to let it save it?
Thanks"
-
Elissa commented
Hi Benoit
I would like to advise that this is now available!
When saving an excel file, using OnePlaceDocs, when the user is prompted to name the file, the dropdown will allow .xlsm file type.
https://d2r1vs3d9006ap.cloudfront.net/s3_images/1385163/excelxlsm.jpg?1458538617
Kind regards
Elissa
-
Elissa commented
Hi Benoit
Saving a file within the application will have this result.
You can save a file as .xlsm if you right click on the email in Windows Explorer, and select 'Send To | SharePoint'
https://d2r1vs3d9006ap.cloudfront.net/s3_images/1212460/xlsm.png?1432856011
This is a feature that is on our product backlog, and when this is included I have made a note to update this thread.
Kind regards
Elissa