Problem with spreadsheet taking a long time to open

I have a couple shreadsheets I have created, one is for Purchase order's and has 4 different sheets. with one sheet holding addresses linked a drop down menu in the first sheet, all in the same workbook. Also there is a macro within this sheet to print to a specific printer, and a specific number of copies when CTRL p is pressed. The total file size is approx 9 mb. Opening this file takes approx 30 to 45 seconds. There are no links to any outside files, only links within the workbook itself.

The second File I have recently started having problems with (Our Quotation log) is A workbook containing 3 sheets, 2 sheets independant and one sheet linked to the second that Summarizes the first and also has cels to enter information on the person the quotation has come from. I have this sheet formatted as a table so I can sort by name etc when doing followups. This workbook also takes approx 30 to 45 seconds to open, and on occasion longer.

All workbooks are stored on my computer. The PO workbook has had the problem since I created it, although the Quotation log workbook has only had the issue this week.

is there any idea what could be causing this issue?

Try removing all the extra formatting outside the data range on your sheets.

Select all the columns unused past the range on the right, then click EDIT ... CLEAR ... ALL.

Select all the rows below the used range... CLEAR ALL again.

Save the book. Check the file size now.

How far down did the file size drop?