In the first worksheet I mark the cells that I want to transfer to another worksheet and press Ctrl-C. There was still an old trick, I don't know if it still works. Windows Version is: Windows 10 Pro 20H2 OS build 19042.1110 Windows Feature Experience Pack have to rephrase the formula.Įxample: Instead of =SUM(BE3:BE37), but = SUM(Sheet1!BE3:BE37). In the annexe I will put a screenshot showing it is switched on automatic but showing the wrong name in the cell. I found another strange issue about this problem, when opening two times Excel, then the name of the second Excel File introduces itself into the cell of the other Excel File !
#SONGKONG NOT UPDATING FILENAME UPDATE#
When printing I would have to pass through all sheets and update them manually one by one and then print one by one.
The only way to update I found is manually refresh the sheet by F9 even though the Excel help says the F9 or Shift F9 is only required if automatic update is off, but it is selected on. I had expected that printing 3 different sheets will give in each sheet the actual sheet name and not in all three pages the same sheet name. When selecting any sheet in the bottom the sheet name in the cell is not updated. = RIGHT(CELL("filename") LEN(CELL("filename")) - FIND("]" CELL("filename") 1)) I use the formula as follows to recover the sheet name, but its not updated in the different sheets: I have used a formula to recover the worksheet name in a cell and when switching from one sheet to the other the update is not done in the cell - is there an option I missed that will allow me to print the n pages of worksheets and have all sheets with the correct names in the sheets ?Īctually when printing the names stay the same of the last updated sheet within all sheets.
0 kommentar(er)
