•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Links to a cell within current worksheet keep changing the location, or doesn't work at all.
Our take
If you're experiencing issues with internal links in your worksheet that don’t consistently direct you to the correct cell, you’re not alone. This can happen when cell references change due to modifications in your data structure. While using simple links seems intuitive, they may not adapt dynamically to changes like row insertions. Instead of relying solely on manual links or the HYPERLINK formula, consider utilizing named ranges or structured references to ensure your links remain accurate, even as your worksheet evolves.
I have a series of titles at the top of my worksheet with links to the most popular categories, hopefully to get to those categories quickly for data entry. I right click on the cell where I want the link, select Link, the enter the cell reference I want to jump to, with the text to display. This works. It presents a link, and if i click on the link, it jumps to exactly where I want it to go. However, over time, the cell reference isn't correct, and jumps to something else. I assume this is happening due to modifications of the worksheet or what it's from. I do not use "$" in the cell reference, assuming that if I enter A720 as the cell reference, the reference will automatically be modified to A730 if 10 rows are added. I have enough of these links that I shouldn't have to modify all of them each time there is an insertion or deletion. I tried using the formula =HYPERLINK(A730, "Category1") or =HYPERLINK('Shawna Smith'!A730, "Category1"), and neither of these work at all. It does not jump to A730 when I click on it. What am I doing wrong, or should I be using another feature or formula? Thank you for your help.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Hyperlink on Excel MobileI am building a complex spreadsheet for an operational task at work. Without going into detail essentially employees that are out on the road will use cell phones or tablets to enter data for employees that are at the home office to print. The current set up is chaos. In my workbook, there are many hyper links that on desktop are one touch however, in mobile, you have to click, two sometimes three drop downs to open the link. I have a mixture of formula hyperlinks that are title words, button style, hyperlinks attached to a text box or picture that are above the cell and within the cell. They all do the same thing. In Excel online some perform as one touch and some you have to open the link then click the link. It would be fine if the clicking wouldn’t result in hyperlinks getting deleted or messed up and I have too many tasks to micromanage the corrections. Does anyone have any suggestions on how to make these perform as one touch on mobile? submitted by /u/Present_Brush7357 [link] [comments]
- Hyperlink does not update when manually changing the date within the URLI have a hyperlink to a web site that is 425-450 characters depending on the account. I have issues. The dates inside the URL change based on month so I cannot hard code the URL in the cell, even though this gets around the function's 255 character limitation when I click on the link. I hard coded the date to April in the URL and it worked, giving me the April data webpage. However, I then did a find/replace to change the date parameters to March dates then clicked on the link, I still got the April data webpage, even though the URL in the Excel cell had March dates. If I choose to hard coded URL and find/replace the dates, how can I make the URL in the Excel cell update to the new date parameters? The webpage did update to March when I clicked on the cell then pressed F2 then click on the link, but I don't want to have to do that for 300 lines. Or, can I use Power Query to help me still use the Hyperlink function, so that the cell only displays the Account number and still work on the ridiculously long URLs? submitted by /u/magickrhythm [link] [comments]
- SharePoint references won't updateHi there. My apologies if this has been asked before - I couldn't find a similar post, but I might have missed something. I have many workbooks that use SharePoint URLs to pull values from separate workbooks. These are just straight up single-cell references, no SUMIFs or anything fancy. Here's an example of one https://preview.redd.it/rfca88yh3ltg1.png?width=1088&format=png&auto=webp&s=067ff28653d6b6a502da71d9f8e471d805cb965a But for the past week or so, these have suddenly stopped updating reliably when the value in question changes. Notably, I do not get a #REF? error or anything like that. This happens even if the workbook it's referencing is open, and it happens in multiple workbooks where I have these kinds of links. A lot of these are columns where each cell references a cell in a column in another workbook. To fix (or make) these links, I copy the column from the referenced workbook and paste as links in the workbook where the links belong, but several times, when I do this, it turns AutoSave off and won't allow me to turn it back on unless I undo the paste, and instead of all paste options showing in the context menu, it only shows paste normal and paste links (no paste formatting, paste formulas, etc.) What the heck is going on?! Does anyone have any ideas? Thank you! submitted by /u/wackywizardz [link] [comments]
- Trying EVERYTHING. I need a drop down list to allow for clickable hyperlinks to external websites.Ok. So I have the drop down list created through data validation (="Report Lists'!$A$1:A$40). It allows me to select the external report names which have embedded URL's. The problem is, it clears the hyperlink on the drop down and makes it plain text. So... What I've found, is to create a =HYPERLINK column next to the drop downs. The problem with that however, is it states "Cannot open the specified file" as it tries to open the text instead of the embedded hyperlink. I cant just directly use the web address as the text name because they are super long, undistinguishable web address names. Any help please? submitted by /u/Gethixit [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#real-time data collaboration#rows.com#natural language processing for spreadsheets#AI formula generation techniques#financial modeling with spreadsheets#real-time collaboration#formula generator#big data management in spreadsheets#conversational data analysis#Excel compatibility#intelligent data visualization#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions