Home

Locking rows before refreshing data

%3CLINGO-SUB%20id%3D%22lingo-sub-467096%22%20slang%3D%22en-US%22%3ELocking%20rows%20before%20refreshing%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-467096%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20add%20information%20to%20a%20report%20we've%20collected%2C%20however%20when%20I%20refresh%20the%20data%20everything%20shifts.%20Is%20there%20a%20way%20to%20lock%20the%20row%20together%20so%20that%20when%20new%20information%20imports%2C%20the%20previously%20added%20information%20stays%20connected.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-467096%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Zbland
Occasional Visitor

I am trying to add information to a report we've collected, however when I refresh the data everything shifts. Is there a way to lock the row together so that when new information imports, the previously added information stays connected.

Related Conversations
Taking values from certain rows based on data input
Drakerla in Excel on
5 Replies
Pulling data from one tab to another
krysphares in Excel on
6 Replies
Problem with sharepoint refreshing
Sibuns123 in SharePoint on
4 Replies
How to SUM Data from non-regular rows
Andy_Przybysz in Excel on
1 Replies