Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    data corruption (xcel 2000)

    I have a problem where something is causing data to be moved from old spreadsheets into current sheets replacing the current valid data. We are using base data sent to us in Excel format to create a series of separate sheets (subsets) for use by interviewers. We split up the base file by copying data into a series of new

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: data corruption (xcel 2000)

    Try saving the files as they come in and save them - in Excel HTML format. Then save the Excel HTML files back into normal XLS format. HTH
    Gre

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: data corruption (xcel 2000)

    This is going to be very difficult to guess what might be happening without seeing all of the workbooks involved. A couple of things that come to mind:

    1- Is the Copy/Paste consolidation done manually, or is there VBA code that is doing the Copy/Paste? If it is code, then there may be bugs in that code. If it is being done manually, no telling what the user is doing.

    2- If there are links in the workbooks to reference data in other workbooks, these links could be getting changed, particularly if you are copy/pasting the links.
    Legare Coleman

  4. #4
    New Lounger
    Join Date
    Sep 2004
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: data corruption (xcel 2000)

    There are no links I can find - nor do we use any VBA code or any form of Macro. At least in the sheets we build. The sheet sent to us that forms the base data is outside our control but it too seems to be OK. I like the idea of saving this as HTML and reopening and savingas XLS.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •