|
|
#1
01-15-2024, 09:45 PM
|
|||
|
|||
Data refresh breaking formulas
I have an Excel workbook with various sheets. 2 sheets are of importance for this issue: 'Extract' and 'SalesExportTable'. The 'SalesExportTable' gets refreshed via a PowerQuery that pulls data from a csv file.
'Extract' makes formula references to sheet 'SalesExportTable'. The issue I'm getting is some formulas in 'Extract' that make reference to 'SalesExportTable' get broken when the data gets refreshed. The easy fix is to rebuild the formulas in 'Extract' but I'd like to fix this permanently. Why do these formulas break? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help with plotting new chart after every data refresh | ebutu555 | Excel | 2 | 08-27-2017 11:37 PM |
| Embedded Excel charts refresh only data values, not which data points (rows) are included | GregL | Word | 0 | 12-01-2016 10:24 AM |
| Multiple questions about Excel project timeline, % formulas, refresh timeline | Please Help | Excel | 0 | 07-27-2016 09:49 AM |
| Automatically refresh data | maestro1 | Visio | 0 | 03-07-2016 05:36 AM |
| Excelchart in Visio, refresh data | sffranz | Visio | 0 | 02-18-2016 09:13 AM |
Windows 11 
Office 97-2003
Threaded Mode