Excel Formula

Topics: User Forum
Mar 10, 2009 at 4:09 AM
Hi there, I have a need to create some 1k sheets.  I have created the master and made some copies of it to try stuff out.  Here is my problem.  The formulas I have in the sheets changes even though I do not write to them.  The formula becomes the + and then the name of the sheet I named it as.  For example, if I had =+F2 in a cell, once I have updated some cells and renamed the sheet to 767, the cell now contains, =+F767.

Any ideas.

If someone has an idea how I can use the 'master' sheet and copy that to my new sheet where after I write my data I would appreciated it.  I simply can't get the format to stick using a master.  My next plan would be to actually format my new sheet.  Does not sound smart but it might work.


Mar 10, 2009 at 6:58 PM
A work item has been created for this:

Temporary work around could be to use a more complex name for your master sheet like 'Sheet1' instead of just '1'.