Force Refresh Pivot Tables and Formulae
Functions to force formula calculation or refresh of pivot tables when the Excel file is opened.
forceFormulaRefresh(file, output = NULL, verbose = FALSE) forcePivotTableRefresh(file, output = NULL, verbose = FALSE)
file |
the path of the source file where formulae/pivot table needs to be refreshed |
output |
the path of the output file. If it is |
verbose |
Whether to make logging more verbose |
forcePivotTableRefresh forces pivot tables to be refreshed when the Excel file is opened.
forceFormulaRefresh forces formulae to be recalculated when the Excel file is opened.
Does not return any results
Tom Kwong
# Patch a file where its pivot tables are not recalculated when the file is opened
## Not run:
forcePivotTableRefresh("/tmp/file.xlsx")
forcePivotTableRefresh("/tmp/file.xlsx", "/tmp/fixed_file.xlsx")
## End(Not run)
# Patch a file where its formulae are not recalculated when the file is opened
## Not run:
forceFormulaRefresh("/tmp/file.xlsx")
forceFormulaRefresh("/tmp/file.xlsx", "/tmp/fixed_file.xlsx")
## End(Not run)Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.