Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Renamed Excel Spreadsheet; Now db download Fails

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Judy Barry
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have an Excel add-in that downloads database data directly into my spreadsheet. Yesterday I renamed it "file-copy.xls" and renamed it back to the original "file.xls". IT KNOWS. Now it won't download any data.

    Error is: CANNOT RENAME A SHEET TO THE SAME NAME AS ANOTHER SHEET, A REFERENCED OBJECT LIBRARY OR A WORKBOOK REFERENCED BY VISUAL BASIC.

    The database provider denies all knowledge of any error like this. I looked in MS Technet and couldn't find anything close.

    Any suggestions? How does it know it was renamed?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    siounds stupid but i suggest change in it back to original nane

    then we can work on,,,,,

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Judy Barry
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I appreciate the simplicity of your answer but I did already. I've been using the spreadsheet with its original name but somehow it "knows" that it was renamed. This interface is a dog. I have 7 unanswered support requests with the interface provider. I just wish I knew more about VB and how the interface works with Excel.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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