Share via

DATA IS SCATTERED

Anonymous
2022-09-23T19:15:11+00:00

I have a simple spreadsheet where I keep track of COD customers. Date, Name, Cust #, Check #, amt, etc. I recently noticed info is no longer together and has been scattered. I only noticed because I highlight COD's that have not been paid. So when I saw yellow cells thrown about randomly (instead of in complete rows), I knew something was wrong and the info was no longer together.

I have filters, but no formulas or charts, etc. Just a simple sheet where I enter info and move on. And now it is a complete untrusted source of important information!

Example:

What info was...

A3 1/20/2022, B3 Barbara Bell, C3 Check# 100

A700 9/20/2022, B700 Bert Bannon, C700 Check# 243

Vs what it is now...

A3 9/2022, B3 Barbara Bell, C3 check 543

A700 6/12/2022, B700 Clyde Corey, C700 Check 243

I honestly don't know how much is wrong since I would have never known if not for those lines that were highlighted. To find them suddenly broken apart and scattered across a vast sea of data is super unnerving. I can't figure out what went wrong for my data to be scattered like this. I can't trust the info. Is there a way to get this back to the way it was??? I've been googling for days but can't find an answer. At least not with how I have been searching.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-09-28T21:02:11+00:00

    I will try that. Thanks much!

    Was this answer helpful?

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Anonymous
    2022-09-28T14:18:19+00:00

    It is not shared.

    The filter is not on. I use the drop down box only when I need to. I was just letting you know I do not have any formulas but I do have a filter in place. And I have tried selecting all and then clearing it.

    It's all pretty confidential. It's account numbers and order numbers, etc, so I wrote over some of the info and deleted rest to take a screenshot.

    So all those yellow lines in the screenshot next to Jan dates belong with Aug details. You'll find yellow boxes in Aug connected to other info in screenshot 2. Basically, info is scattered and I do not know to what extent since I wouldn't have caught it if not for the highlighted lines breaking apart. I'd have to check every order against the system and re-do an entire new sheet. What could cause this? Thanks

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-09-24T14:56:40+00:00

    Dear Artemis,

    Welcome to the forum here.

    From your description, it seems that each row of the Excel data doesn't show the correct values in the Excel file.

    If yes, may I know whether the Excel file is shared online and edited by other users?

    It seems that you have filters on the Excel file. If you clear he filters, what's the result?

    About the issue in your environment, could you upload some related screenshots?

    Note: Remove any private information before uploading the screenshots.

    Thanks for your effort and time.

    Sincerely,

    Cliff | Microsoft Community Moderator

    Was this answer helpful?

    0 comments