Pipeline Deals Integration

%3CLINGO-SUB%20id%3D%22lingo-sub-1725276%22%20slang%3D%22en-US%22%3EPipeline%20Deals%20Integration%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1725276%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20spreadsheet%20that%20our%20office%20uses%20to%20look%20at%20KPI's.%20We%20also%20use%20Pipeline%20Deals%20to%20track%20everything.%20We%20are%20looking%20to%20use%20the%20Pipeline%20Deals%20Sync%20Integration%20so%20we%20do%20not%20have%20to%20manually%20enter%20the%20data.%20The%20problem%20we%20are%20facing%20is%20that%20the%20sync%20is%20deleting%20everything%20in%20our%20sheet%2C%20when%20we%20need%20it%20to%20start%20on%20row%2014.%20Our%20formulas%20and%20KPI's%20are%20all%20on%20rows%201-13.%20Is%20there%20a%20way%20we%20can%20start%20the%20sync%20on%20row%2014%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1725276%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1726491%22%20slang%3D%22en-US%22%3ERe%3A%20Pipeline%20Deals%20Integration%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1726491%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F813579%22%20target%3D%22_blank%22%3E%40ryanamato%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3EI%20would%20assume%20the%20easiest%20way%20is%20to%20let%20PiplineDeals%20Sync%20Integration%20download%20to%20a%20worksheet%20and%20then%20use%20PowerQuery%20to%20read%20that%20worksheet%20and%20update%20your%20table%20(List1).%20Set%20the%20Query%20to%20refresh%20automatically%20periodically.%20See%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Frefresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Frefresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

I have an excel spreadsheet that our office uses to look at KPI's. We also use Pipeline Deals to track everything. We are looking to use the Pipeline Deals Sync Integration so we do not have to manually enter the data. The problem we are facing is that the sync is deleting everything in our sheet, when we need it to start on row 14. Our formulas and KPI's are all on rows 1-13. Is there a way we can start the sync on row 14?

1 Reply

@ryanamato ,

I would assume the easiest way is to let PiplineDeals Sync Integration download to a worksheet and then use PowerQuery to read that worksheet and update your table (List1). Set the Query to refresh automatically periodically. See: https://support.microsoft.com/en-us/office/refresh-an-external-data-connection-in-excel-1524175f-777...