It sounds like your colleague has the ability to set a default download location for files, while you do not. This feature is likely controlled by a setting in the spreadsheet application you are using.
Here are a few things to check that may help you access the same setting:
- Check the application's settings or options menu. Look for a setting labeled "downloads," "file handling," or something similar.
- Check if you are signed in to the application with the same account as your colleague. Some settings may be specific to a particular account.
- Check for updates to the application, as new features are often added in updates.
- Check if you are using the latest version of the spreadsheet application
- Check if your colleague has a different version of the spreadsheet application than you.
- Check if your colleague has access to a feature that is not available to you.