if its gone red, it could be because the names of the red dimensions/ measures don't exist in the same format in your data source any more. I'd start by looking for the red dimensions/measures in your data source. Another possibility is that your data type has changed (eg a date has become a number). Your could also do a check there to make sure the types are what you expect.
always helps if you can post a version of your workbook here :-)