Dear Ben,
Thanks for your updates and confirmation.
Regarding "Currently although the workbook includes the table lines I have put in, the print preview does not. Therefore, areas of my table appear to be one large cell.", could you share some screenshots showing the table view and the print preview view in your environment?
Meanwhile, I'd like you to upload a full screenshot of the Account page in the Excel application you are using for our reference. You can access the file via opening Excel>clicking on File>Account.
Note: Remove any private information before uploading the screenshots.
If you copy and paste the table to a new Excel file and go to the print preview view, what's the result?
Could you also share the file for us to do a test in our environment?
If the file and the file link can be shared here directly, please add your confirmation and share the file link here.
If no, welcome to let us know and we'll take the next step to collect the file.
Thanks for your effort and time!
Sincerely,
Cliff | Microsoft Community Moderator