Jul 01 2019 05:54 AM
I have been working with EXCEL 365 2016 on Windows 10. I have spreadsheet with hundreds of hyperlinks and am having trouble sorting, moving, cutting and pasting information. the file usually goes into 'not responding' and hangs up. I store the data on my SSD along with the EXCEL app.
Is there some type of limitations with excel and hyperlinks? I try to sort on the column that has hyperlinks and sometimes it works and sometimes it does not sort accurately.
I basically had the same problem when I was using EXCEL 2010.
Thank you
Jul 01 2019 08:01 AM
Jul 01 2019 10:02 AM
Here is a small sample of what I have. The original spreadsheet has over 5000 rows with numerous hyperlinks. The Hyperlinks are to a website called 'findagrave.com'
I plan on importing them into ACCESS when I have completed updating each row. That is I follow each link. look up and copy information from that site and copy them into my spreadsheet. When importing them into ACCESS some of the links worked and some didn't even tho' i used the field as HTML. The file was so big that I created different spreadsheet for each state, but still have the same issues.
I could delete the hyperlinks when I am done editing but until then I need them. I thought there may be a quick fix but maybe not.
Thanks for your time.
Jul 02 2019 12:58 AM