data losing library

rjmdc

Active Member
Joined
Apr 29, 2020
Messages
405
Office Version
  1. 365
Platform
  1. Windows
hi
this is an issue that keeps happening
i created a linked set of payment workbooks
one is for the data entry (book 1) the other for the payments (book 2)
both are created of multiple sheets based on PQ
they share their info
book 1 gets info via index and match/update
book 2 gets the info via query

each of the pages has numerous macros all intertwined - it emails, prints statements, prints checks, add the check totals, creates labels

every so often either of the books just declares "cant find project or library"
in my previous book when i didnt make backups i lost all my data and all my codes
now i backup at every closedown (forced by macro) so when it fails i retrieve a backup
but i know something is wrong.
this shouldnt be happening.

can anyone help me figure out what and if we are doing something wrong?
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Watch MrExcel Video

Forum statistics

Threads
1,130,112
Messages
5,640,174
Members
417,130
Latest member
Darion2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top