cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
Want to know more about how Community ideas impact Dropbox development? Check it out here

Dropbox files & folders

Get in sync with the Dropbox Community. Our members can answer all your questions on Dropbox files and folders. Join a discussion or start your own today.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Excel file macros do not work in shared dropbox folder

Excel file macros do not work in shared dropbox folder

aalter
New member | Level 2

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 longer work and the file is not automatically sorting. What is going on. Why does it disable macros?

6 Replies 6

Re: Excel file macros do not work in shared dropbox folder

Daphne
Dropboxer

Hi @aalter, thanks for reaching out to us here!

 

Do you have the file set to automatically run the macro when opening it?

 

Or are you able to run the macro once you open the file manually?

 

If you're getting any errors, please send along a screenshot of this.

 

Looking forward to hearing from you!


Daphne
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, please give it a Like below.
:arrows_counterclockwise: Still stuck? Ask me a question!
:pushpin: Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.

Re: Excel file macros do not work in shared dropbox folder

aalter
New member | Level 2

Nothing is working. I would need a specialist to help me. 

 

I do not know where to input the code to automatically run macros in the workbook.

 

Manually run macros gives me this error. See attached photoScreenshot 2020-12-04 130835.png

Re: Excel file macros do not work in shared dropbox folder

Daphne
Dropboxer

Thanks for your update here @aalter.

 

In this case, I wouldn't be able to help much further with this, so I would suggest reaching out to Microsoft Support for some assistance with this.

 

They will have a much better insight into this since it's within the Excel app that you need to take these actions.

 

I hope this helps to some extent, just let me know if you have any questions!


Daphne
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, please give it a Like below.
:arrows_counterclockwise: Still stuck? Ask me a question!
:pushpin: Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.

Re: Excel file macros do not work in shared dropbox folder

MRRalfacomputer
New member | Level 2

Hello everyone,

I have exactly the same issue here.

I have a Dropbox business sharing folders and files with another Dropbox business.
Both users open the excel files on a desktop (mine is an OSx, hers is a Windows PC).

The thing is: I created a file on excel with macros that works perfectly on both computers, but in hers, it just works if the file is saved and opened from OUTSIDE the dropbox shared folder.

When the excel file with macros opens on her computer from the dropbox shared folder, it does not even ask to able or disable macros. It acts like there are no macros at all.

Can someone please help me?

Thank you

 

Re: Excel file macros do not work in shared dropbox folder

Walter
Dropboxer
Hey @MRRalfacomputer, sorry to jump in here, but I think you'll find your answer in this discussion

At your convenience, please take a look and let us know if you have anything else to ask.

Walter
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, please give it a Like below.
:arrows_counterclockwise: Still stuck? Ask me a question!
:pushpin: Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.

Re: Excel file macros do not work in shared dropbox folder

Yashwant Ingle
New member | Level 2

I need to run the macros I chose dropbox and shared .xlsm file with one user but we are not able to take action or run the macros using dropbox. I chose to open file using excel for web but same ..

Actulally after filing information upon clicking button or image the macro runs also upon right click of mouse the macro runs but it's not happening online using dropbox share.

I need this to work essentially as this is team work for us.

Who's talking

Top contributors to this post

  • User avatar
    Yashwant Ingle New member | Level 2
  • User avatar
    Walter Dropboxer
  • User avatar
    MRRalfacomputer New member | Level 2
  • User avatar
    Daphne Dropboxer
  • User avatar
    aalter New member | Level 2
What do Dropbox user levels mean?
Need more support?