Macro with consolidation function not working when using the file in Dropbox folder

Hi all,

I have worked a lot on a personal organizer with a consolidation function retrieving infos of other sheets on the same workbook. I used a macro to consolidate each time I use the file.

My problem is that the path to the consolidation sheets is pointing to a wrong location. When I uses the file on my desktop, it works perfectly. But I really want to use it on Dropbox for ease of access.

My file was initially in the Dropbox folder and here are the steps I have taken to do the macro:
Record the Macro
1) Consolidate date from sheets using the table name ex: perso, quadruplex, etc.)
2) sort, etc.)
Stop recording.

Basically, it works perfect, but when I use again the macro, it says Cannot open consolidation source file 'main-to-do-list.xlsm'.

Please help me to fix this. I am very STUCK and don't know what to do to fix it.

Please Login or Register  to view this content.

up, please help.

up, please help