ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Duplicate Files (https://www.excelbanter.com/links-linking-excel/155708-duplicate-files.html)

misschanda via OfficeKB.com

Duplicate Files
 
Hello,
I have inherited a bunch of data, that is named under different folders
however the information inside the folders are the same.
In other words I have two folders one named " LabFolder" and the other Lab
Folder"; however the information in both are the same...

Is there a command to rid excell of duplicate information. The files in both
folders are the exact same.

thanks
la

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...links/200708/1


Bill Manville

Duplicate Files
 
Misschanda via OfficeKB.com wrote:
Is there a command to rid excell of duplicate information.

I don't know what sort of "duplicate information" you mean.
The only thing I can think of that Excel "remembers" is recently used
files.

You can remove them by deleting registry keys in
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\E xcel\Recent Files

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup


misschanda via OfficeKB.com

Duplicate Files
 
Where do I input this information???
thx
LA
Bill Manville wrote:
Misschanda via OfficeKB.com wrote:
Is there a command to rid excell of duplicate information.


I don't know what sort of "duplicate information" you mean.
The only thing I can think of that Excel "remembers" is recently used
files.

You can remove them by deleting registry keys in
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\ Excel\Recent Files

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...links/200708/1


Bill Manville

Duplicate Files
 
Misschanda via OfficeKB.com wrote:
Where do I input this information???


Sorry, but I still don't know what information you are referring to.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup


misschanda via OfficeKB.com

Duplicate Files
 
Where do I find the register Keys???
Thanks
LA


Bill Manville wrote:
Misschanda via OfficeKB.com wrote:
Where do I input this information???


Sorry, but I still don't know what information you are referring to.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup


--
Message posted via http://www.officekb.com


Gail Richner

Duplicate Files
 
Registry keys are found using the command regedit through Start - Run
**However be warned editing your Registry can cause your computer to become
inoperable if you do make changes**




"misschanda via OfficeKB.com" <u36612@uwe wrote in message
news:77d1007aacbf8@uwe...
Where do I find the register Keys???
Thanks
LA


Bill Manville wrote:
Misschanda via OfficeKB.com wrote:
Where do I input this information???


Sorry, but I still don't know what information you are referring to.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup


--
Message posted via http://www.officekb.com




Herbert.

Duplicate Files
 
I'm not sure, but something like that happend to me, I create a Excel or Word
document, and the same file appear in my both disks, C: and J:, the same with
my folders. I'd like to use J: only for System files, not for save data,
because my Virtual memory is too small. I always delete the duplicates files
in J: from time to time.

"misschanda via OfficeKB.com" wrote:

Hello,
In other words I have two folders one named " LabFolder" and the other Lab
Folder"; however the information in both are the same...

Is there a command to rid excell of duplicate information. The files in both
folders are the exact same.

thanks
la

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...links/200708/1




All times are GMT +1. The time now is 10:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com