1) Do the replace data source like mentioned below
2) Use the replace references concept if they are any misalignment in the columns
After replacing data source, if you dont want that T|F column and you are not using it any where in the sheet delete it
or if you are using and if there as replacement to that column use the replace references comcept
after i replace the data source , there are many red exclamations marks appeared on some I'm not sure how to solve it? do u want me to put the two files here??
the exclamation marks indicate that all the fields category does not exist in the database?
it means those fields are not available in replaced data source use the replace preferences if that field names have been changed
else attach a workbook along with excel which you want to change i will help to replace the data source and attach back
do u have an email address that I can send to you? I cant seems to upload here .thanks so much DB:)
Or Open the thread instead opening from Inbox , click on Reply --> Advance editor and add a attachment on the top right corner of the edit dialog --> there you can add the files
I have sent to your email much thanks:)