close

I have a workbook that pulls data from various sources. Under
EDITgt;LINKSgt;STARTUP PROMPT, I chose quot;don't display the alerts and update
links.quot; However, on startup not only does Excel display the alert, initially
it shows link errors until they are fixed manually.

Is there an explanation and, more importantly, a fix for this?

Note that the workbook has VBA code under quot;this workbookquot; which
automatically removes sheet protection, updates the Pivot Table and
reprotects the workbook. The workbooks from which it pulls data has the same
type of VBA code.

Thanks for your help

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄