How to not refresh every row in a table (pivot table)

%3CLINGO-SUB%20id%3D%22lingo-sub-2113848%22%20slang%3D%22en-US%22%3EHow%20to%20not%20refresh%20every%20row%20in%20a%20table%20(pivot%20table)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2113848%22%20slang%3D%22en-US%22%3E%3CPRE%3E%3CSPAN%3EHello%20community!%0A%0AFor%20my%20work%20I%20am%20busy%20making%20a%20man%20%2F%20production%20planning.%20Now%20I%20have%20been%20able%20to%20connect%20to%20our%20ERP%20system%20via%20SQL%20so%20that%20all%20current%20employees%20and%20current%20orders%20are%20always%20up%20to%20date%20in%20my%20workbook.%0AStill%20I%20am%20not%20completely%20sure%20how%20I%20want%20to%20refresh%20the%20table%2Fconnection%20(manually%2C%20a%20refresh%20button%20with%20a%20manully%20made%20macro%2C%20built-in%20VBA%20or%20via%20Task%20Scheduler)%2C%20but%20I%20think%20it%20will%20depend%20on%20my%20question.%20In%20the%20orders%20tab%20I%20entered%20an%20x%20%E2%80%8B%E2%80%8Bnumber%20of%20standard%20'orders'%20manually.%20These%20are%20things%20like%20absent%2C%20yet%20to%20be%20planned%2C%20logistics%2C%20etc.%20So%20these%20are%20not%20actually%20orders%2C%20but%20I%20do%20want%20to%20have%20them%20in%20this%20way.%20Now%20it%20is%20true%20that%20when%20I%20refresh%20the%20table%20%2F%20connection%20these%20orders%20are%20removed%20by%20Excel%20(which%20is%20not%20surprising%20in%20itself).%20But%20is%20there%20a%20possibility%20to%20have%20my%20table%20%2F%20connection%20refreshed%20and%20then%20not%20include%20the%20first%20x%20number%20of%20rows%3F%0A%0AI%20have%20added%20two%20photos%20for%20clarification.%20In%20photo%201%20you%20will%20see%20an%20orange%20parts%20which%20I%20do%20not%20want%20to%20be%20refreshed.%0AThanks%20in%20advance!%0A%0AKind%20regards%2C%3CBR%20%2F%3EBas%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Schermafbeelding%20niet%20vernieuwen%20spec.%20regels.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F252238iD5F79A07901CCAE4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Schermafbeelding%20niet%20vernieuwen%20spec.%20regels.jpg%22%20alt%3D%22Schermafbeelding%20niet%20vernieuwen%20spec.%20regels.jpg%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Schermafbeelding%20neit%20vernieuwen%20spec.%20regels%202.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F252239i8E31CBD87AC884F1%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Schermafbeelding%20neit%20vernieuwen%20spec.%20regels%202.jpg%22%20alt%3D%22Schermafbeelding%20neit%20vernieuwen%20spec.%20regels%202.jpg%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor
Hello community!

For my work I am busy making a man / production planning. Now I have been able to connect to our ERP system via SQL so that all current employees and current orders are always up to date in my workbook.
Still I am not completely sure how I want to refresh the table/connection (manually, a refresh button with a manully made macro, built-in VBA or via Task Scheduler), but I think it will depend on my question. In the orders tab I entered an x ​​number of standard 'orders' manually. These are things like absent, yet to be planned, logistics, etc. So these are not actually orders, but I do want to have them in this way. Now it is true that when I refresh the table / connection these orders are removed by Excel (which is not surprising in itself). But is there a possibility to have my table / connection refreshed and then not include the first x number of rows?

I have added two photos for clarification. In photo 1 you will see an orange parts which I do not want to be refreshed.
Thanks in advance!

Kind regards,
Bas

Schermafbeelding niet vernieuwen spec. regels.jpgSchermafbeelding neit vernieuwen spec. regels 2.jpg
0 Replies