Excel keeps copying deleted files

G

Guest

How do I prevent Excel making copies of files I delete? When I try to delete
the copied files, further copies are made! Any advice appreciated.
 
G

Gord Dibben

Very strange behaviour.

How are you deleting the files? Via Windows Explorer? VBA via Excel?

Please post some more details.


Gord Dibben MS Excel MVP
 
G

Guest

When I click on "open" to search for a particular file, I see all these
copies of the deleted files.
 
G

Guest

I delete them while in Excel - by clicking "open" and then when I see an
unwanted file, clicking "delete"...
 
D

David

=?Utf-8?B?Um9zaWU=?= wrote
I delete them while in Excel - by clicking "open" and then when I see an
unwanted file, clicking "delete"...
Click to expand...

Are the 'deleted' files preceded by the words "Copy of"?

What happens if you highlight them and press the Delete key on your
keyboard?

Do you see the word 'Delete' pop up in a little yellow box when you hold
your mouse pointer over the Delete button for a couple of seconds?
 
G

Guest

Yes, the files are preceded by "copy of".

Usually I delete by right clicking on the mouse and choosing the delete
option. When I delete using the keyboard as you describe, I get the message
"are you sure you want to delete (filename)?" I don't quite understand what
you mean by holding "the mouse pointer over the delete button". Anyway, I
don't see any little yellow box popping up...
 
G

Guest

Dear all

Problem solved! It turns out that the problem arose when I was multiple
selecting files to delete by holding the Ctrl or Shift key while left
clicking to select the
files. The copies are created when you fail to completely release the mouse
button before you move the pointer to another file. If a group of selected
files is dragged...even the slightest bit...the next mouse click will
produce copies
of all the previously highlighted files.

Thought you would be interested. It also applies to non-Excel applictaions -
I was getting the same problem in Jasc.

Thank you for trying to help.

Rosie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing matters 10
Copying cells working only sporadically 2
Windows 7 Difference in "size on disc" between files and copied files - a problem? 3
How do I stop Excel from making copies of files? 1
personal Excel file opens with 2 copies 1
How do I remove an Autoshape? 3
Excel 2007 and "owner files" 1
Macros: can you copy macros from one doc to another? 1

Top