data link

Hi, I currently have a spreadsheet that includes lots of pages imported from external data (an external website). The links that I used were similar to: https://www.twitrss.me/twitter_user_to_rss/?user=barkingcollege However recently there has been an issue with a security certificate on...

Hi all...I've been dipping in and out of this really useful forum to improve my Excel skills immensely...so thanks for the help. I am however struggling to solve what is probably a fairly straight forward bit of coding...something until last week I had no experience with. I have a regularly...

Does any know how to make an indirect file link work using the Indirect function? The formula is =INDIRECT("'c:\temp\[Indirect File Link.xlsx]"&$A$1&"'!A6") With the file (Indirect File Link.xlsx) open the above formula works ok. With the file closed I get #REF! returned. Any help would be...

I have a large metrics Excel 2013 workbook with a lot of hidden tabs with data links pulling data into tables. I have a handful of these set to refresh upon opening the file...which causes a warning upon opening the file to update links or not. Can this warning be turned off so the user...

does anyone know how to set up a link between an excel spreadsheet and an autocad civil 3d file? civil 3d is .net capable, and somewhat with VBA. If a link is not possible, is there a way to get the data off the civil 3d file with a VBA or .net?

I want to use a VLOOKUP formula to pull data from additional workbooks. I would like to use constants/dimensions in VBA to reference the “table_array” in the formula. The pathways will always stay the same but the name will change to the date. The formula will bring back the data but I have to...