This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 42%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDF%3C/text%3E%3C/svg%3E)
hi,
i have an excel file that uses macros and userforms.
when file is opened it copies some data from another workbook saved in
a Dropbox and loads a userform. this has been working perfectly for a few years
now but recently the form takes a long time to load.
another user has reported getting run-time errors when he opens
the file.
there have been no changes to the file or code.
does anyone have any ideas on what may be happening?
thanks
Doug
An implementation of Visual Basic that is built into Microsoft products.
further info:
all users (4 people) are reporting problems running the program now.
we are all running individual copies of the program and all have their
own copy of excel.
this only started happening on friday.
we are getting 'excel not responding' errors and if we do get in we are getting
various run-time and 400 errors.
heard there are changes to how macros are being handled - wondering if
it could be something to do with that? everything was working perfectly for years.
any thoughts would be appreciated.
Doug
Answer accepted by question author
DropBox changes their algorithms. Many DropBox implementations that were made 10-12 years ago no longer work at all. Your macro will need re-writing. You might consider using OneDrive instead, as Microsoft is invested in making sure it works seamlessly with Office.
Was looking at switching to Onedrive so I will give it a try.
will post in the next few days if issue is solved.