Link to home
Start Free TrialLog in
Avatar of Chris Slack
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.
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

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.

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.

User generated image
Avatar of Chris Slack
Chris Slack

ASKER

I don't have that option in my version of excel. I'm currently using Office 2013.
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial