When the original spreadsheet was deleted, I started to get the reference not valid error message, when I selected one of the random cells.I know you dont want to use VBA but this is a small line that might do the job: Application.DisplayAlerts False.Tim wrote: the name refers to: - OFFSET(ATC DataC1,0,0,COUNTA(ATC DataC:C),23) after i click the message box, everything continues to work normally (the pivots all show the correct data, suggesting the range name is okvalid).One included a response from Stephen Bullen: The most common reason Ive seen for this is if you have a chart in your file and delete the columnsrows containg its source data.
Excel Table Source Reference Not Valid Pro With MultipleRegards Stephen Bullen Tim wrote: Hi All, i have a workbook xl2002, xp pro with multiple pivot tables based on the same data range (another sheet in the same book). Tim Dave Peterson wrote in message news:42DCDF32.A873ADF9verizonXSPAM.net. You may want to search google for that phrase. Thinking it might return a range with a REF range. We are what we repeatedly do. ![]() Well good luck, hope it turns out ok A -- We are what we repeatedly do.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |