Hi, I have an excel sheet , on which I use "import from Web" ( Google Sheet ). For past couple of days, some values are missing on the excel sheet.. I was able to figure out that the missing values are ones that are generated (in google sheet) as part of an Arrayformula .
for example, in column A, an Array formulae on Cell A17 in inserted, which fills the remaining cell under cell A17, whenever a new row is added. In Excel, I can see values till A17 but nothing beneath it.. Tried making a new excel file , but outcome is the same.
Below are the SS on both Google sheet & Excel Data Editor
Any help is much appreciated.
Best Regards,
Prabha
for example, in column A, an Array formulae on Cell A17 in inserted, which fills the remaining cell under cell A17, whenever a new row is added. In Excel, I can see values till A17 but nothing beneath it.. Tried making a new excel file , but outcome is the same.
Below are the SS on both Google sheet & Excel Data Editor
Any help is much appreciated.
Best Regards,
Prabha