New Column Added To SQL Table Not Showing Up In Excel?

**ostinoh** · 02-09-2012, 05:37 PM

Hello -

I currently have a table that my users connect to via excel and report off of. I had to add a column back to the SQL table and now two things are happening.

1. When they refresh the data the new column does not get added. If they start a new workbook it will get pulled in and in the right space.

2. Some have seen when they refresh the column is added to the end and not in the right column space.

Thoughts or ideas on how I can fix this? Because some of the users have macros and other pivot tables.

Thank you in advance.
D

**Bmoe** · 02-20-2012, 11:22 AM

For both questions I would check the connection definition. The SQL information is kept in one spot and if the source data changes it may not be reflected at all. That is why the new workbook people get it (I think) They are generating a new connection file. I don't know how to do it in 2010, but in 2007 you could put the cursor in the range where data comes back and click the properties to view the definition string.

I've just recently started generating a file for the definintion and pointing all datalinks to that file instead of excel making it's own. That way I can refresh the one file and all the users get the new information.

New Column Added To SQL Table Not Showing Up In Excel?

LinkBack

Thread Tools

Rate This Thread

Display

New Column Added To SQL Table Not Showing Up In Excel?

Re: New Column Added To SQL Table Not Showing Up In Excel?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions