IMPORTRANGE cannot take its URL or tab name from a cell
IMPORTRANGE needs a typed-in URL or sheet name, so links and tab names cannot come from a cell or be built dynamically.
Tier I · Proven The best-established problems.
5 public reports · first reported 9 January 2019 · last reported 18 November 2024
What's going wrong
People who update a source link or report tab every week want to change one cell rather than editing each formula.
AI-assisted: written with the help of AI from the reports. The idea report has the full summary.
In the idea report
- The full summary.
- The products the 5 reports are about, and how many came each month.
- Related problems.
No business has been found with this problem yet, so the report has no contacts. All sales are final — no refunds. Pricing.