lost data

  1. A

    Table data not extracted - Power query

    Hello, I am getting data from an excel workbook within a folder Sheet has 3-4 rows at the top with couple of titles and blank rows, Then there is a table below these few rows. I am cleaning these few rows by removing them and then promoting headers from the table below. The issue is that some...
  2. B

    Excel 2007 auto-recover path - cannot find .xar files

    Good afternoon A colleague of mine still uses Excel 2007 and had a document saved on a Network Drive They have been working on this all day without saving, although the auto-recovery is enabled for every ten minutes She accidentally closed excel down without saving I have searched in the...
  3. R

    Excel only allows one character per cell!

    I am a basic Mac-based Excel user producing budgets, cashflows etc, though we are cross platform at work. While working on budgets at home today I noticed that Excel had started displaying only one character (letter or numeral) in a cell. Any cell. Each character replaces the one before. I...
  4. P

    Lost Text When Using Two Instances of Excel

    Hi. Copying and pasting cells from a worksheet in one instance of Excel to a worksheet in another instance of Excel results in the text being truncated. I have a laptop display extended to a VDU so I have two instances of Excel open so that I can view two Excel files at the same time...
  5. B

    Pivot tables no longer linked to data - HELP!

    Hi All, I'm working in Excel 2007 in Excel 2003 compatibility mode in order to share with others using Office 2003 on a long set of pivot tables in a worksheet tab labeled "PTable" that as created off another worksheet labeled "Source Data" for days and all was good. I open the workbook today...
  6. A

    Excel Data Suddenly Lost!

    I made some changes to an excel file (added a new sheet, changed the order and numbers on first sheet) and when I opened the workbook today all the changes are lost! There is no reason for this happening - my data was successfully saved previously. Is there any way to restore the lost data...
  7. B

    Rows of data lost after closing an excel file

    I am bringing data from Microsoft Access into Excel 2003. When I paste the data in, all the data I have copied is there in Excel. After saving my worksheet all the data is still there. If I close out of the Excel file and re-open it I only have 16,110 rows of data. The rest is gone. It is...
  8. F

    Screen went blank and is now grey

    I was working on a very detailed Excel budget spreadsheet. I was moving the cursor and my finger slipped and I must have activated a menu button by accident. The entire spreadsheet is now grey and looks like it is hung up waiting for a response. The menu options are opaque. When I click on...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top