Share via

Create an external reference to an undefined cell range in another workbook

Anonymous
2022-06-15T19:25:50+00:00

I have a source excel file and a report excel file

My issue is that the data I’m working with in the source file can be 100 rows one time and 10,000 rows the next. The columns and column names remain the same, but the # of records can greatly vary from one time to another. There are pivot tables that I need to consider in the report file so just choosing code that pulls over 10.000 rows can be a problem with the reports.

Is there code I can work with to make this no longer be an issue??

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-06-16T15:17:17+00:00

    Dear Shubha,

    Good day! Thank you for posting to Microsoft Community.

    According to your description, using Excel to pull over 10,000 rows may cause Excel performance issues. If so, you can use Microsoft Access to manage data. Please check if the following references may help.

    Move data from Excel to Access

    Introduction to queries

    Also, as you mentioned, you want to know if VBA code can help you in this situation, since our team focuses on general query, for example, installation and activation issue of Office 365 products, you can to refer to this article: Office VBA support and feedback | Microsoft Docs to go to Stack Overflow by using the VBA tag, along with any other relevant tags as there are also many experienced engineers and experts in the forums there.

    Disclaimer*: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites, or any support related to technology.*

    At the same time, we will also keep this thread open, so other Community members and Experts can also share their suggestions and inputs.

    Thank you for your cooperation and understanding!

    Best Regards,

    George

    ***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***

    Was this answer helpful?

    0 comments