Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Mar 2006
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Loosing Formula References (Excel 2003 SP2)

    Hi Everybody,
    We have a large workbook with a sheet of data that is imported in and a summary sheet that we want to summarize using mostly SUMPRODUCT functions. We got the summary worksheet to work properly with existing data but when we tried to update the data with new data by copying and pasting new data in we got this error #VALUE! we feel that we are close to a solution but are missing one last key step.

    Any help would be appreciated. <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Loosing Formula References (Excel 2003 SP2)

    Welcome to Woody's Lounge!

    Without knowing the structure of the worksheet(s) it's hard to say what causes the error. You could try using Edit | Paste Special > Values instead of simply pasting the data.

  3. #3
    New Lounger
    Join Date
    Mar 2006
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Loosing Formula References (Excel 2003 SP2)

    Hi Hans,

    The error message said the error is of the wrong data type. I tried your solution but it did not work. Thanks for the suggestion anyway.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Loosing Formula References (Excel 2003 SP2)

    This kind of problem is hard to troubleshoot from a distance. Could you attach a small, sanitized workbook demonstrating the problem? Remove or modify sensitive data.

  5. #5
    New Lounger
    Join Date
    Mar 2006
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Loosing Formula References (Excel 2003 SP2)

    Hi Hans.

    With regret, I cannot send you a file that details the problem but I can send you a little demo that shows what we would like to do and it works fine. The data we are receiving comes from SQL and the main part of the problem comes from data that we truncate using the combination of the left and search functions. We do not need to involve the search function in the demo that we are sending you but the data is more complex and requires the left search function combination.

    Thanks for getting back to us.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Loosing Formula References (Excel 2003 SP2)

    The formulas in the Summary sheet in your workbook refer to DataSheet. If I copy data from DataSheet2 and paste them into DataSheet, the formulas still work.

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

    Re: Loosing Formula References (Excel 2003 SP2)

    Your question is similar to my telling you that my car will not start. I can't show you my car, but here is a car that works like I want my car to work. Please tell me how to make my car work like the one that works.

    It is going to be extremely difficult to help if you can't show us what does not work.
    Legare Coleman

  8. #8
    New Lounger
    Join Date
    Mar 2006
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Loosing Formula References (Excel 2003 SP2)

    Thanks Hans for helping us out. We were able to solve our little dilemma. It seems that our Data file was incorrect which in turn created our error message.

    We are all better now. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  9. #9
    New Lounger
    Join Date
    Mar 2006
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Loosing Formula References (Excel 2003 SP2)

    Unfortunately, due to client and file size restrictions, we were not able to send the actual file. Thanks anyway for your concern. We have since been able to fix the problem.

    Regards <img src=/S/notmyfault.gif border=0 alt=notmyfault width=15 height=15>

Posting Permissions

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