Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Excel merge or synchronize

I have a client with 2 Excel 2007 documents. Lets name then excel1 and
excel2. Now the client has always worked in excel1. Recently however the
client suffered a system failure and excel1 was lost. Excel2 is a backup copy
of excel1, but it hasnt been backed up for more than 2 months, thus 2 months
worth of information has to be redone.
Urgent work has to take place and the client starts adding current data to
excel2 from 2day, thus there is a month data gap in the file.
Thru the wonder of hard drive recovery I was able to recover excel1 today.
Is it at all possible to merge or synchronize excel1 and excel2 with each
other so that one of them is completely up-to-date?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Excel merge or synchronize

There's no automatic way of doing this. You'll need to look at the data
structure and decide which parts from which file you need, then do copy and
paste.
--
David Biddulph

"Bob" wrote in message
...
I have a client with 2 Excel 2007 documents. Let's name then excel1 and
excel2. Now the client has always worked in excel1. Recently however the
client suffered a system failure and excel1 was lost. Excel2 is a backup
copy
of excel1, but it hasn't been backed up for more than 2 months, thus 2
months
worth of information has to be redone.
Urgent work has to take place and the client starts adding current data to
excel2 from 2day, thus there is a month data gap in the file.
Thru the wonder of hard drive recovery I was able to recover excel1 today.
Is it at all possible to merge or synchronize excel1 and excel2 with each
other so that one of them is completely up-to-date?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 34
Default Excel merge or synchronize

On Feb 27, 4:04*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
There's no automatic way of doing this. *You'll need to look at the data
structure and decide which parts from which file you need, then do copy and
paste.
--
David Biddulph

"Bob" wrote in message

...



I have a client with 2 Excel 2007 documents. Let's name then excel1 and
excel2. Now the client has always worked in excel1. Recently however the
client suffered a system failure and excel1 was lost. Excel2 is a backup
copy
of excel1, but it hasn't been backed up for more than 2 months, thus 2
months
worth of information has to be redone.
Urgent work has to take place and the client starts adding current data to
excel2 from 2day, thus there is a month data gap in the file.
Thru the wonder of hard drive recovery I was able to recover excel1 today.
Is it at all possible to merge or synchronize excel1 and excel2 with each
other so that one of them is completely up-to-date?- Hide quoted text -


- Show quoted text -


You may try a popular Excel file recovery tool called Advanced Excel
Repair to repair your Excel file. It is a powerful tool to repair
corrupt or damaged Excel files.

Detailed information about Advanced Excel Repair can be found at
http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Hope this will help.

Alan
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't Synchronize Excel List with Sharepoint TommyVee Excel Discussion (Misc queries) 0 July 27th 07 10:08 PM
synchronize excel 2003 to sharepoint 2007 Atul Mehta Excel Discussion (Misc queries) 0 July 6th 07 08:08 PM
In Excel 2002, how do I synchronize data with other worksheets? JVorch Excel Discussion (Misc queries) 3 February 5th 07 10:52 PM
How to synchronize different Excel files kuvulmaz Excel Discussion (Misc queries) 0 February 7th 06 12:11 PM
HOW DO i SYNCHRONIZE MULTIPLE WORKSHEETS IN EXCEL? saranat New Users to Excel 7 May 2nd 05 07:19 PM


All times are GMT +1. The time now is 08:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"