Hello there.
I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about how to solve the Excel problem like as follows:
When opening an Excel file. Have you ever been annoyed by the message?
"This workbook contains links to other data sources.
Tip Quiz
Do you know what is the shortcut for filling cell formula down from the adjacent cell above?
Hereafter steps to do:
1) Select the "Data Tab" on the ribbon.
2) Click on "Edit Links" that it is a submenu in Connections Group.
3) Click on "Startup Prompt" on the left below of the menu box.
4) Then just tick the option you want in the round box. If you choose "Don't display the alert and don't update automatic links" as shown below, this alert message will never display again.
5) Save it immediately.
All tasks are finished! Enjoy your work.
That brings me to the end of my posting.
Tip Answer
Link recommendedπ : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'
Link recommendedπ : English Numbers In Words 1 to 1000000
Thanks for reading.
Bye,
Posted by: Michael Leng
I've known, then I've grown.
See more tips:
I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about how to solve the Excel problem like as follows:
The Excel Worksheet display "This Workbook Contains Links To Other Data Sources"
When opening an Excel file. Have you ever been annoyed by the message?
"This workbook contains links to other data sources.
- If you update the links, Excel will attempt to retrieve the latest data.
- If you don't update the links, Excel will use the previous information.
Tip Quiz
Do you know what is the shortcut for filling cell formula down from the adjacent cell above?
1) Select the "Data Tab" on the ribbon.
2) Click on "Edit Links" that it is a submenu in Connections Group.
3) Click on "Startup Prompt" on the left below of the menu box.
4) Then just tick the option you want in the round box. If you choose "Don't display the alert and don't update automatic links" as shown below, this alert message will never display again.
5) Save it immediately.
All tasks are finished! Enjoy your work.
That brings me to the end of my posting.
Tip Answer
Link recommendedπ : English Numbers In Words 1 to 1000000
Thanks for reading.
Bye,
Posted by: Michael Leng
I've known, then I've grown.
See more tips:
Thank you Very Much for the TIP. My problem is solved now.
ReplyDeleteGlad that it helps.
Delete