You might see that the Dropbox Community team have been busy working on some major updates to the Community itself! So, here is some info on what’s changed, what’s staying the same and what you can expect from the Dropbox Community overall.
Forum Discussion
Excel file macros do not work in shared dropbox folder
I have an excel spreadsheet on my desktop computer that uses macros in order to automatically sort my tenants. When i upload this spreadsheet into a shared file folder with my partners, the macros no...
I created an important document for my Dropbox for Business team which extensively uses macros and is thus an .xlsm file. However, none of the macro features are necessary when the team uses the file online. Their sole purpose is to harness Visual Basic to rapidly produce external content in Word. The intent is for users to occasionally download the newest online version of the file, generate the local content they need using the desktop-exclusive macros, then delete or ignore the file and return to online use. The spreadsheet, however, is still an important resource for the team to use online without macros. In particular, the team prefers access to the Filter View system which is only available in Google Sheets.
When I uploaded the .xlsm file to Dropbox, I was disappointed to realize that it would no longer open in GSheets; only Excel Online, which does not support Filter Views. Obviously it supports general filters, but those are neither (1) usable by only 1 person at a time without affecting all other users viewing the sheet, like Filter Views, nor (2) able to be saved to the sheet for use later, like Filter Views. This does not make much sense to me because I can open the same macro-enabled file in my personal Google Sheets without issue. Is there anything that can be done to enable my team to work on this file in DB online, ignoring the macros entirely as intended? Thanks!
- Walter
Dropbox Staff
Hey yggdrasilsyeoman, sorry to hear you're having issues with this.
I'm not sure if this would help, but have you considered converting the file to another format, a .xlsx file for example?
This would enable you to open and edit the files with Google Sheets.
I have the same problem.
if you have it as a xls file The macros doesn’t work. It needs to stay in a xslm file.
Do you have a solution or are you looking at this . Really need macros to work on this platform to make it perfect for my business
