Results 1 to 7 of 7
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Liniks - Linked document now corrupt (Excel 2000)

    The error is caused by copying the copy of the copy of the copy of a sheet. Excel has two names for a sheet; the one you see and a code name, that is only visible in the visual basic editor. It is that name your error message is babbling about.

    You may be able to open the file in Excel 97.
    Once succeeded, go to the VBE, in the project explorer expand the project with your filename. Click on the sheets and make sure the properties window is visible. Now in the properties window you should see a (name) property that has teh strange sheetname next to it. Change this name by editing the text and pressing enter. Make sure you use a unique name!

    If the file won't open, you can try these options:

    Options to try and open a corrupt file

    - Set calculation to manual
    - open the file, but disable macros (assuming you've set macro security to medium: Tools, Macro, security)
    - As soon as you've clicked the disable macros button, press control-pageup or control-pagedown, thus changing sheets.

    If that does not work, try creating a link to the file:

    ='c:my documents[MyFileName.xls]Sheet1'!A1

    and copy right and down. This at least gets you the worksheets values.

    Sometimes the Excel viewer (or Word) enables you to open the file and copy information out of it.

    Also, Excel XP can sometimes repair XL files with trouble.

    Good luck!

    BTW: did you try Bill's FINDLINK as I suggested?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Smithfield, Free State, South Africa
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Liniks - Linked document now corrupt (Excel 2000)

    Thanks Jan
    I opened the workbook in Excel 97 and modified the name of all 80 sheets as you suggested. That worked fine until I tried to change the name of the the last sheet - 81!
    I keep getting Dr Watsons. The sheet has been names 141111111211111 (or something like that). Is there any way I can delete this sheet or something?

    PS I could not get my download copy of Bill's FINDLINK to work.
    The one I tried was the Microsoft one which gave me all these funny page names.

    What I am actually doing is creating a time sheet and invoice that I copy for every new month - that is why there are so many sheets!!!

    Maybe there is another way of opening a new month and place the 'structure' in without copying the sheet?

    Regards

    Lynden

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Liniks - Linked document now corrupt (Excel 2000)

    You could try deleting it in the usual way in XL97 (rightclick the tab and delete)?

    To avoid trouble like this, have one original sheet and copy that sheet each time. Don't copy the copy of the copy of the copy, because each copy will add a 1 to the code name (at least, that used to be the case in XL97 and should have been fixed in XL2000).
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Smithfield, Free State, South Africa
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Liniks - Linked document now corrupt (Excel 2000)

    Thanks again. I tried the right click > Delete option and good old Dr Watsons visited me again, and again. I think I'm getting chronic!
    Nothing I tried seems to allow me to delete the offending sheet.

    The other bit makes sense because the original document was created in 97 and then converted to 2000.

    Your good advise of having sheets as "templates" is great as well - it makes further sense now understanding what happens.

    I have not yet sorted out the delete links problem, but I think another few months until the end of the year won't be too much of a problem.
    Bill's FindLink does not want to work now!!

    Take care

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Liniks - Linked document now corrupt (Excel 2000)

    Well, then lets just copy all good sheets to a new workbook and forget about the old one!

    BTW: Bills findlink works fine for me, what goes wrong?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    3 Star Lounger
    Join Date
    May 2002
    Location
    Smithfield, Free State, South Africa
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Liniks - Linked document now corrupt (Excel 2000)

    <P ID="edit" class=small>(Edited by WebGenii on 08-Oct-02 12:54. added hyperlink)</P>I downloaded a deletelinks application as suggested from the Microsoft site (Dellinks.xla The Delete Links Wizard Add-in.) from the following address:
    http://support.microsoft.com/default.aspx?...US;Q188449&

    During the running I received an error message (see attached document) and now the original linked document is corrupt displaying the message every time I wish to open it.
    I can see the contents in the background, but I get a Dr Watsons error and the document closes.
    Any ideas?

    Any idea how I can retrieve the contents of the document?
    Attached Files Attached Files

  7. #7
    3 Star Lounger
    Join Date
    May 2002
    Location
    Smithfield, Free State, South Africa
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Liniks - Linked document now corrupt (Excel 2000)

    Thanks, thanks, thanks.
    Now Bill Manville's FindLink works as well.
    Much appreciated and a wonderful learning experience.
    Cheers

Posting Permissions

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