I have an Excel spreadsheet that we display on large TV screen. It looks great all the columns are aligned to fit on the screen (in portrait mode).
The spreadsheet does an access update every 5 minutes. This works great too.
But when the spreadsheet updates it will adjusts the column widths to largest field in the access database and then the spreadsheet will not look correct on the screen anymore. Usually it will shrink the row down. I 've tried to password the sheet but then access will error with message it can't update.
Any Ideas on how to control this. I don't want to create a blank record that will have the right amount of spaces it might look funny have 1 blank line displaying.