referencing a cell from another tab in my worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2734558%22%20slang%3D%22en-US%22%3Ereferencing%20a%20cell%20from%20another%20tab%20in%20my%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2734558%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20creating%20a%20worksheet%20with%20a%20Bid%20tab%20and%20Data%20tab.%3C%2FP%3E%3CP%3EWhen%20I%20reference%20a%20cell%20in%20my%20bid%20tab%20to%20pull%20the%20cost%20from%20the%20Data%20tab%2C%20it%20adds%20it%20in%20but%20it%20doesn't%20keep%20it%20even%20if%20I%20hit%20save%20right%20after.%26nbsp%3B%20Does%20anyone%20know%20if%20there%20is%20a%20setting%20to%20prevent%20my%20formula%20from%20disappearing%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2734558%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2736077%22%20slang%3D%22en-US%22%3ERe%3A%20referencing%20a%20cell%20from%20another%20tab%20in%20my%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2736077%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F396937%22%20target%3D%22_blank%22%3E%40TonyaMon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20never%20heard%20of%20a%20formula%2C%20once%20entered%2C%20disappearing.%20Can%20you%20give%20a%20more%20complete%20description%20of%20what%20you're%20doing%2C%20perhaps--ideally--posting%20a%20copy%20of%20the%20spreadsheet%20in%20question%20(so%20long%20as%20it%20contains%20no%20confidential%20information).%20But%20specifically%20be%20clear%20about%20what%20the%20formula%20is%20that%20you're%20using%20to%20pull%20data%20from%20%22Data%22%20into%20%22Bid%22%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am creating a worksheet with a Bid tab and Data tab.

When I reference a cell in my bid tab to pull the cost from the Data tab, it adds it in but it doesn't keep it even if I hit save right after.  Does anyone know if there is a setting to prevent my formula from disappearing?

 

Thank you in advance.

1 Reply

@TonyaMon 

 

I've never heard of a formula, once entered, disappearing. Can you give a more complete description of what you're doing, perhaps--ideally--posting a copy of the spreadsheet in question (so long as it contains no confidential information). But specifically be clear about what the formula is that you're using to pull data from "Data" into "Bid"