The IMAGE function in Google Sheets calls the images inside the cells via an URL. This makes it impossible for the images to be available in offline mode.
To fix this, you can use the embed function to convert the images to objects inside the cell and this way the images will be available offline.
Once the images are embedded, this cannot be undone or reversed.