My new BOM is 10 times bigger than my drawingHow can I resize it to fit on my page
1) Change the font size. Your default font size may be too large.
2) Perhaps you need to place the BOM on another sheet and use more than one table width, i.e. break it up.
Got any pictures?
The BOM is just one spreadsheet that (depending on options selected) will include everything.
You need to split you BOM. Here's how...
2019 SolidWorks - Splitting BOMs
Lunch & Learn - Let's Understand SOLIDWORKS BOM - YouTube
Can you post screen shots of your BOM and drawing?
You typed "new BOM", does this mean there was a previous BOM that did not go 10X?
How many line items are in your BOM?
As others have typed above, sometimes a BOM can get large depending on the number of line items, the number of columns, the amount of data in each cell, the font size and type and the drawing's size.
What is your drawing's sheet size?
Redesign your assembly to use fewer components...
But seriously, as has been mentioned, the BOM size is dictated by its contents. You can reduce the amount of contents, reduce font size, and/or reduce the cell padding.
You have a very tiny sheet size?
Retrieving data ...