Created attachment 40469 [details] Test sheet for sheet copy bug Problem is that if I have few sheets in one document which are linked and pulling data from each other, when I copy sheet it doesn't preserve data source in formulas. In attachment you will find document which uses VLOOKUP to get certain data from other sheets. Try to make copy of first sheet via right clicking on sheet name and choosing "move/copy sheet" option. Then you leave everything as it is, you just mark "COPY" checkbox at bottom and click OK. With pink I marked rows in which formula data source will change. For example, original formula from cell F11: =VLOOKUP($A11;'10'.$A$1:$O$200;9;0) will change to =VLOOKUP($A11;'SVI MJESECI NEMJENJAJ'.$A$1:$O$200;9;0) As you can see, data source changed from sheet '10' to sheet 'SVI MJESECI NEMJENJAJ' which is first sheet on the left from old '10' sheet. On a sheet copy everything should stay same...
Hi, It's not a bug. You used relative sheet reference. =VLOOKUP($A11;'10'.$A$1:$O$200;9;0) add $ in front of the sheetname and it will works. =VLOOKUP($A11;$'10'.$A$1:$O$200;9;0)
I know there is workaround for this with $ sign, but isn't it illogical if you want COPY of sheet for program to automaticly change data refrences? I want exact copy of sheet with slitly different sheet name. Call it feature request if you want then! :)