I'm working within a large workbook. I have a data tab and in another tab I have several formulas pulling from the information in that data tab. If the data is filtered it will change my answer to the formula in this particular tab (i.e. it’s only calculating on the filtered data). Other tabs are fine in this workbook and the formula answer will stay the same no matter if you filter the data tab or not.
Do you know how to get those tabs to stop calculating on the filtered data?
Thanks!
What are your formulas?
Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks