Change reading source for multiple cells

[salminenaa]

I have a xls file that has a lot of cells reading data from another cell in the same page. Now I want all the cells to read data from the same cells as they do now but in another page. I understand that I can manualy add 'Page_name' in front of all formulas but since there is over 10000 different formulas I hope there is a way to add it to all in a easier way?

[Sam Capricci]

well depending on your formula you can always do a find and replace.
so let's say you have =SUM(B1001:D1001) and you want to repoint it to another tab, using find >> B1001:D1001 and replace with >> Sheet2!B1001:D1001
then replace all and you've pointed it to another sheet.
to get a better answer post an example of the formula you are using and the formula you want and we can give you a better answer.

[salminenaa]

All reading cells is reading from different cells so all forumulas are different. Almost all are shaped like this so maybe i can search for =OM (Om is swedish for IF) and make a replace for all =OM to something with 'Tab_name' in it? But how do I keep the rest of the formula?

=OM(ANTAL(P17)=0;" ";RANG(P17;P$14:P$18;1))
=OM(ÄRTAL(L18);L18-MIN($L$14:$L$18);"")
=OM(B18<>"";B18;"")

[Sam Capricci]

Well I can't read Swedish (my problem, not yours ) but say that there is something common in many like you want to change from P$14:P$18 to Sheet2!P$14:P$18 and find and replace and as long as you don't have the find and replace as match entire cell contents checked it will change for those you have.
Now when I've done this, due to different formulas I've sometimes had to run it several times to cover all the ranges.
A different way would be if you are using specific formulas in areas, of course making the change to the first then double clicking on the bottom corner will autofill the formula for as far as it has to go (forgive me if you already know this because I don't know how skilled you are in excel).