asked on

Eliminating the phantom files created in Excel 2007 whenever an Excel document is open

Is there a way to get rid of the phantom files created in Excel 2007 whenever a document is open? Such as:

~$SDAE Template_v5.0_Oct 14 7-31 PM.xlsm

To me it's unnecessary clutter that makes it annoying trying to find the document that you want to open, especially when you have 3 or 4 or more open. I'm running XP if that's relevant.

Thanks,
John

sysreq2000

I believe those are the autorecover files. You can turn autorecover off in the "Save" portion of the Excel Options (click on the top left logo and "Option" will be at the bottom of the menu.

You can also change the location where they're saved so they don't bother you in your usual documents folder.

SOLUTION

sysreq2000

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

John Carney

ASKER

Thanks, sysreq2000. I'll be here. - John

ASKER CERTIFIED SOLUTION

redmondb

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

redmondb

John,

If you're dealing with a limited number of un-shared files that are repeatedly causing you this issue then there is a ludicrous work-around. On the other hand, if this is simply your general Excel folder with files being continually created then it isn't appropriate.

Let me know your situation, please.

Regards,
Brian.

John Carney

ASKER

Thanks for your answers. I've decide d this just matter that much so I'm awarding the points based on the fact that you've both educated me somewhat and I appreciate that.

- John

redmondb

Thanks, John. Sorry I couldn't resolve your issue.