Chris Slack
asked on
Excel and Access update spreadsheet issue
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.
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.
ASKER
I don't have that option in my version of excel. I'm currently using Office 2013.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
so is that mean your Excel got a data source which linked to an Access database? To avoid the width to be adjusted automatically after data source is refreshed, try to un-tick the "Adjust column width" option and try again.
you may also adjust other settings to change other refresh behaviors.