Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-10-2023, 12:59 PM
JHalter JHalter is offline Windows 10 Office 2019
Advanced Beginner
Edit Link
 
Join Date: Nov 2021
Posts: 46
JHalter is on a distinguished road
Default Edit Link


We keep seeing this message "We can't update some of the links in your workbook right now" How does linking to a workbook work and how do we fix this?
Attached Images
File Type: png Error Message.PNG (47.3 KB, 8 views)
Reply With Quote
  #2  
Old 01-10-2023, 02:07 PM
spillerbd spillerbd is offline Edit Link Windows 10 Edit Link Office 2021
Competent Performer
 
Join Date: Jan 2016
Posts: 130
spillerbd is on a distinguished road
Default

Under the DATA Ribbon, look for the Edit Links. That will identify the files used in formulas. The file path may be obscured if it is long.
If you have access to the INQUIRE add-in, you can run a Workbook Analysis to identify cells using external links and the formula with the external link.
Reply With Quote
  #3  
Old 01-19-2023, 03:33 PM
Guessed's Avatar
Guessed Guessed is offline Edit Link Windows 10 Edit Link Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

The Edit Links dialog shows the links in formulas that are easy to find.

Unfortunately there are other places that links can hide that are WAAAYY harder to track down. Also unfortunately, those sneaky links can get added by copy/pasting ranges from other workbooks without first making sure those features are not being used in the copied ranges.

The other places that external links might be hiding are in:
- Named Ranges
- Validation Lists
- Conditional Formats
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatic link creation, after writing: Link text in main body (multiple instances) mike_302 Word VBA 2 07-05-2021 12:28 AM
Edit Link Converting html link to ms word link myUserNamez Word 2 01-04-2017 10:47 PM
Trying to link page numbers in the footer, but refuses to link after new section fl0shizzle Word 7 05-06-2014 12:15 PM
How to link an object to a URL link to update automatically expert4knowledge Excel 1 06-11-2012 09:30 AM
MarkAsFinal - 'Edit Anyway' edit popup issue GovindRS PowerPoint 1 06-20-2011 06:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft