HeyItsTyler
New Member
- Joined
- Dec 12, 2018
- Messages
- 3
Hello,
I am having an issue with extra rows and columns in a worksheet (will be referenced to as A), specifically with a data connection into another workbook (B). Worksheet A does not have currently have data beyond row 100, but the rows and columns (in the scroller) extend to excel's limit, which leads to a massive amount of cells for the data connection to pick up and input into workbook B and eventually crashes from the memory usage. There is another worksheet in the same workbook as worksheet A that is also connected to workbook B and extends to row ~500 and the connection works fine. There is also no VBA coding in these workbooks if that were to cause any type of issue.
Is this an issue with worksheet A cell formatting or data connection settings?
Any direction would be greatly appreciated.
I am having an issue with extra rows and columns in a worksheet (will be referenced to as A), specifically with a data connection into another workbook (B). Worksheet A does not have currently have data beyond row 100, but the rows and columns (in the scroller) extend to excel's limit, which leads to a massive amount of cells for the data connection to pick up and input into workbook B and eventually crashes from the memory usage. There is another worksheet in the same workbook as worksheet A that is also connected to workbook B and extends to row ~500 and the connection works fine. There is also no VBA coding in these workbooks if that were to cause any type of issue.
Is this an issue with worksheet A cell formatting or data connection settings?
Any direction would be greatly appreciated.
