Thread: Unable to make changes to data table without losing during update

Hi all,
I'm hoping someone can help me because no one at my office can figure this out. Anyways, I have a Excel doc that includes a table that pulls data from our servers and autopopulates the fields. The variables include: Release Date, Creator, Title and Date Submitted. My job requires that I sort through hundreds of items and make sure each title has a working landing page on our website. I need a way to mark which items are complete and which items have problems. I can't figure out a way to add this information to this document without it becoming disassociated from the title when I refresh the list.

Is there any way I can add a column to this table, without having it sync on the servers that will associate to the other 4 columns?

For example, I would ideally like to have 4 columns refresh from the servers (Release Date, Creator, Title and Date Submitted) and 1 column (Project Status) that does not sync to the server, but the data remains related to the refreshed items when updated.

Right now, no matter how I try to do this, once I update the list, the Project Status field loses it's association and is then matched to a new item.


FYI: I can't add the Excel doc due to corporate privacy concerns, so I will try to answer your questions as best as I can.

Yes, the data is being pulled using a SQL query. I'm very new at using SQL, especially in an Excel doc so I'm not completely sure how to do what you are suggesting. Do you know of any instructional guides or links that describe this in more detail? I can currently sort the data by it's Title ID, which is an 8 digit alphanumeric value assigned to each title. These are not sequential though, so I'm not sure if that matters. Would this work or are you referring to some other type of identifier?

I think it's probably worth mentioning here that I have read-only access to the database so I can't change anything about it, only pull information.

Originally Posted by tlafferty

Are we talking about using SQL to pull the data from? If so, consider developing a view into the data which includes a sort based on the data's ID. Assuming your data has sequential numeric identifiers, this should take care of the problem. Point your table at the sorted view.