We help IT Professionals succeed at work.

Excel and Access update spreadsheet issue

Chris Slack
Chris Slack asked
on
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.
Comment
Watch Question

Ryan ChongSoftware Team Lead

Commented:
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.

tmp.jpg
Chris SlackIT Consultant

Author

Commented:
I don't have that option in my version of excel. I'm currently using Office 2013.
Software Team Lead
Commented:
try go to Data > Queries & Connections

tmp.jpg