| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula uses previous saved spreadsheet data!
Basically I produce a report on forecasts ever month. i created the sheet oh
the 28th and saved as New 'Forecast report - 28.09.09' for the time bring. Today I wante to update it with the latest data but the Formulas are using the previous reports sheet with the pivot table (entitled 'Pivot'). how do i get rid of this connection? The Formula is: =IFERROR(IF(F2="Forecast based on inv data",IF(VLOOKUP(A2,'[New Forecast report - 28 09 09.xlsx]Pivot'!$C$6:$M$1048576,4,FALSE)=0,"",VLOOKUP(A2,'[New Forecast report - 28 09 09.xlsx]Pivot'!$C$6:$M$1048576,4,FALSE)),IF(VLOOKUP(A1,'[New Forecast report - 28 09 09.xlsx]Forecasted Items'!$A$5:$T$1048576,3,FALSE)=0,"",VLOOKUP(A1,'[New Forecast report - 28 09 09.xlsx]Forecasted Items'!$A$5:$T$1048576,3,FALSE))),"") I would delete the 'connection address' but theres 12 columns for every month and it takes time manually doing this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I KEEP DATA (SPREADSHEET EXCEL) FROM SHRINKING WHEN SAVED? | Excel Discussion (Misc queries) | |||
| How do I restore a previous version of a file I changed and saved | Excel Discussion (Misc queries) | |||
| entering new data in a saved spreadsheet without losing formulas? | New Users to Excel | |||
| Can I access the previous version of a saved file? | Excel Discussion (Misc queries) | |||
| How can I open previous version of saved file in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
