User Profile
Liam502
Copper Contributor
Joined Jun 29, 2023
User Widgets
Recent Discussions
Use formula to determine which workbook to reference
I have one workbook which must compile data from many smaller workbooks. In column A of the main workbook, I have the names of the smaller workbooks which need to be referenced. I need to dynamically reference each workbook individually. I have attempted to do this using the INDIRECT function, but have had no luck. For example, if I wanted to reference cell B6 in the small workbook in the A2 cell of the main workbook, I'd write: =INDIRECT("["&"A2"&".xls]B6 This isn't working for me. Any suggestions?Solved768Views0likes1Comment- 1.1KViews0likes0Comments
Actual risk of automated updates of links
Hello, My work involves a lot of repetitive copying from one spreadsheet into another. I want to remove some of the tedium from this process by linking the spreadsheets using formulas, so that I wouldn't even need to open the other spreadsheets to get their information. I understand that the automatic update of links is "not recommended" by excel, as it can be a security concern if the spreadsheet is linked to a malicious website. However, we make all the spreadsheets ourselves, and they do not contain and links to websites, they are simple spreadsheets containing numerical and text data. So, would it be safe for us to enable the automatic update of links? ThanksSolved1.3KViews0likes2Comments
Recent Blog Articles
No content to show