In short, PI ProcessBook caches data from PI snapshot, while DataLink does not.
PI ProcessBook trends update data from snapshot in real time and cache them at the client, so when the archive is somehow interrupted, the client won't be affected unless you hit refresh, which clears the client side cache and pulls data all over again from server archive(for history) & snapshot(for current value).
PI DataLink retrieves data from archive each time you calculate the spreadsheet. It does not cache snapshot values over time to create a history data record or trend. That's the main reason you are seeing this difference between PB and DL.
You could also contact OSIsoft (now part of AVEVA) techsupport for help.