Jan 25, 2020
Array result was not expanded because it would overwrite data in D5.
I have use case for Google Sheet.
I have third party software which writes data to a Google Sheet. Google sheet has 5 columns
With IMPORTRANGE function I am writing data to another Google sheet. I intend show lastRow fields in a template attached to this google sheet. Plus if I make changes to template, fields in the google sheet should be updated.
However I am always receiving an error "Array result was not expanded because it would overwrite data in D5."
Kindly suggest
Thanks
Farheen
Details
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
All Replies
Jan 25, 2020
However I am always receiving an error "Array result was not expanded because it would overwrite data in D5."
this simply means what it says
that the formula is being "interuptted" from writing its result because there is data in said cell
delete that data & formula result will expand
unless - there is more data blocking its path