+ Reply to Thread
Results 1 to 12 of 12

error message. How to get rid of the message?

  1. #1
    Registered User
    Join Date
    09-16-2023
    Location
    Spain
    MS-Off Ver
    365
    Posts
    42

    error message. How to get rid of the message?

    Hello Xelers,

    does anyone have a solution to get rid of this error message?
    I am receiving this message everytime I am updating my pivot tables.

    The message in english means:
    The data of file "HuAteamlast9..."were not being able to load from tab "https://d.docs.live...."

    Thank you very much
    Thomas

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,018

    Re: error message. How to get rid of the message?

    Check is your workbook linked to another workbook (Data -> Workbook links) and break the link.

  3. #3
    Registered User
    Join Date
    09-16-2023
    Location
    Spain
    MS-Off Ver
    365
    Posts
    42

    Re: error message. How to get rid of the message?

    Thanks zbor,
    but there are no links when checking. The workbooklinks are not clickable.
    Attachment 877352

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,839

    Re: error message. How to get rid of the message?

    Selecting attachment 877352 results in the following error message: "Invalid Attachment specified. If you followed a valid link, please notify the administrator"
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Registered User
    Join Date
    09-16-2023
    Location
    Spain
    MS-Off Ver
    365
    Posts
    42

    Re: error message. How to get rid of the message?

    I am resending the attachment. It only shows that the "workbook links" are greyed out. Not clickable.
    workbooklinks.jpg

  6. #6
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,525

    Re: error message. How to get rid of the message?

    Check your file with Bill Manville's tool - FindLink

    Artik

  7. #7
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,971

    Re: error message. How to get rid of the message?

    Does your workbook use an external query to get the data for the pivot table?
    Everyone who confuses correlation and causation ends up dead.

  8. #8
    Registered User
    Join Date
    09-16-2023
    Location
    Spain
    MS-Off Ver
    365
    Posts
    42

    Re: error message. How to get rid of the message?

    No, not an external query, but an internal query to a tab inside the same file. That tab has been deleted as no longer in use.

  9. #9
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,971

    Re: error message. How to get rid of the message?

    You can't really refresh a pivot table if you deleted its data source.

  10. #10
    Registered User
    Join Date
    09-16-2023
    Location
    Spain
    MS-Off Ver
    365
    Posts
    42

    Re: error message. How to get rid of the message?

    Quote Originally Posted by romperstomper View Post
    You can't really refresh a pivot table if you deleted its data source.
    I am receiving the error message, that it cannot be refreshed. I wish to get rid off that message as it cannot be refreshed any longer. But that message stays. That is my issue.... getting rid of that meassage...

  11. #11
    Registered User
    Join Date
    09-16-2023
    Location
    Spain
    MS-Off Ver
    365
    Posts
    42

    Re: error message. How to get rid of the message?

    The error message in german language...Attachment 877513

  12. #12
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,971

    Re: error message. How to get rid of the message?

    You either have to copy and paste it as values to remove the pivot, or stop using RefreshAll.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Replace error message with text message
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2017, 02:37 AM
  2. An error message on open - a totally blank VBA message box
    By Mr_Tigas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-05-2013, 11:29 AM
  3. Error Message For Function Procedure WITHOUT using a message box
    By bmr8002 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2012, 02:01 PM
  4. Replacing run time error message with a different message
    By penny in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-14-2009, 10:51 AM
  5. [SOLVED] replace VBA run-time error message with custom message
    By BEEJAY in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-14-2006, 11:05 AM
  6. [SOLVED] changing the message in an error message
    By The Villages DA in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2005, 01:34 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1