Forum Discussion
Excel Performance Issue with Linked Workbooks - Data Update Delay
Hi Microsoft Community, We are experiencing a performance issue with linked workbooks in MS Excel. Here’s our problem statement: We have two workbooks (Workbook1 and Workbook2) that contain one or ...
If you format the source data as a table and then create a range name that points to just the body of that table, you can link to the range name from your other workbook. This ensures you do not need to have your formulas point to any empty rows.