Excel is deleting your formulas and leaving behind static numbers, and that is not a user error, it is a fundamental flaw in how the application handles file movement. The experience described by this Reddit user is maddeningly precise: references vanish without warning, no error messages appear, and the only trace left is the orphaned value. This is not a broken link or a corrupted file. This is Excel silently converting a live formula into a dead number, and it happens during routine folder transfers inside DropBox. For anyone managing cost sheets, bid calculations, or any multi-sheet workbook, that behavior is a productivity trap.
The core problem lies in how Excel handles external and internal references during file relocation. When a workbook is moved between folders, especially across synced cloud directories, Excel sometimes treats the original file as "unavailable" long enough to decide that the reference cannot be resolved. Instead of showing a #REF error, which would at least alert the user, it pastes the last calculated value and erases the formula. The user in this story had no luck reproducing the issue in test files, which suggests the timing of DropBox's sync process plays a role. The folder may briefly become inaccessible during the move, and Excel defaults to "safe mode" by destroying the formula rather than waiting. That is not helpful. That is destructive.
What makes this worse is that the fix is not obvious. Adjusting Trust Center settings, enabling content prompts, and even stress-testing file moves did not stop the problem. The user's colleague is the only one experiencing it, which hints at a combination of DropBox sync timing, Excel's calculation options, and possibly a difference in Excel versions or update status. The practical takeaway is that this pattern, formulas erased during folder moves, is not rare. It has been reported across forums for years, and Microsoft has not addressed it cleanly. The workaround is to avoid moving the file at all. Keep the workbook in a single, stable folder and let the team access it through shared links or mapped drives. If movement is unavoidable, open the workbook, copy all sheets into a new file in the target folder, and delete the original. That breaks the sync cycle.
The deeper lesson here is about trust in tools that claim to be automatic. Excel's formula engine is powerful, but its behavior during file relocation is fragile. If your workflow depends on references surviving folder moves, you need a system that does not assume the file path stays static. This is where AI-native spreadsheets offer a real advantage: they treat data as connected by meaning, not by file path. A formula in a modern spreadsheet does not care which folder the data lives in, because the reference is to the data itself, not to a cell coordinate inside a specific file. Until then, the only reliable answer is to stop moving the file. Keep your formulas in one place, and let the sync software adapt to you, not the other way around.