OFFSET replacement to get rid of save prompt

[RiP235]

Is there any other formula instead of OFFSET?
Because Excel prompts to save every time I close it even if I don't change anything.
Here's my formula: G5=OFFSET(G5,-1,0)+F5-E5
And if I use this formula, auto-update won't work in table: G5=G4+F5-E5

 

[Redwolfx]

If you want to get rid of the save prompt all together, open VBA and on the before close add thisworkbook.saved = True

 

[FDibbins]

cross-posted here...
OFFSET replacement to get rid of save prompt

 

[RiP235]

Oh sorry, but can't edit post.

OFFSET replacement to get rid of save prompt
OFFSET replacement to get rid of save prompt

If you want to get rid of the save prompt all together, open VBA and on the before close add thisworkbook.saved = True

So it saves the workbook even if I don't wanna save some data? Then it's not good

 

[Redwolfx]

No it just tells the system the file has already been saved. Even though it hasn't

 

[RiP235]

No it just tells the system the file has already been saved. Even though it hasn't

And what gonna happen if I change/add some data and forgot to save it?
If it doesn't ask so it's not good again

 

[FDibbins]

Well you cant have it both ways...either you get the prompt to save or you dont.

 

[RiP235]

Solved by replacing via INDEX: =)

G5=INDEX(G:G,ROW()-1)+F5-E5