Compatability between excel & google sheet formulas..

Hi,

I'm having some sort of trouble with the compatibility of formula between excel and Google sheet,i made an spread sheet and
i have uploaded it to the Google drive,

Below formula works perfectly well on spreadsheet,when i add a workbook named "1" it would catch up the data without any fuss,but google
sheet doesn't do so,any solutions..

I could manually copy and paste the formulas in the google sheet and it is giving result,i'm looking for another solution

=IFERROR(INDIRECT("'1'!$L"&ROW($L10)),0)

Thanks,
Ak

Thanks JB but it didn't help, I think we will have to incorporate something like now() into the formula to act as a trigger to have it update more often.

Any Suggestions...

Thanks,
Ak

Martin it will work if the book "1" exists already,in my case "=IFERROR(INDIRECT("1!$L" & ROW($L10)),0)" formula is there
on my summary book and book 1 doesn't exist,whenever i required the book 1 i make it,then the formula in the summary doesn't update..

hope you got my point..

Thanks,
Ak

There is some confusion with your terminology - I think you mean that you are adding a SHEET named 1, not a BOOK.

Perhaps your calculation mode is set to Manual - press F9 after creating the sheet to see if it re-calculates.

Hope this helps.

Pete

Yes i mean a sheet,i pressed F9 after inserting a sheet but nothing happened..

Martin i tried your way also still no luck.
any other options..

Originally Posted by martindwilson

i just played around with it. looks like google sheets does not update the indirect unless you change something inside the indirect
take
=iferror(INDIRECT("'4'!$l"&ROW($L10)),0) and there is no sheet called 4
insert a sheet name it 4 put something in l10 say xxxxxxx
=iferror(INDIRECT("'4'!$l"&ROW($L10)),0) stays as 0 despite trying to re-enter it
change something inside the indirect like remove the $
=iferror(INDIRECT("'4'!l"&ROW($L10)),0) then enter and it updates