#1
|
|||
|
|||
Error in exporting Google Sheet to Excel
Hi,
Whenever I export a certain Google Sheet to Excel, I receive the following Excel notification: 'We found a problem with some content in 'XXSHEET NAMEXX.xlsx.'Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.' So.... I click 'Yes,' and... when I open the Excel doc, all formulas are still working and the sheet looks totally fine. HOWEVER, when I press 'Enable Editing,' I receive the following notification: Window title: 'Repairs to 'XXSHEET NAMEXX.xlsx'' Text: 'Excel was able to open the file by reparing or removing the unreadable content. Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded. Repaired Records: Worksheet properties from /xl/workbook.xml part (Workbook)' And then, when I review a certain tab with formulas, I simply see the word "#VALUE!' replacing every single formula value. I've tried copying certain tabs into new Google workbooks, but when I download those the same thing happens. Help? |
#2
|
||||
|
||||
Perhaps a Google docs forum could help?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Thanks; posted there as well.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
=filter() feature of google sheets not in EXCEL | peter.threepins | Excel | 1 | 07-13-2016 08:44 AM |
ADODB import of Excel data results in "Run-time error -2147467259: <sheet> is not a valid name." | misaak | Excel Programming | 3 | 06-20-2016 07:55 AM |
Exporting to Excel in MSP | c991257 | Project | 7 | 05-15-2016 07:58 AM |
Exporting workbook specific sheet columns on exit | shabbaranks | Excel Programming | 4 | 08-21-2012 08:00 AM |
Exporting to Excel | lhicks | Outlook | 1 | 07-13-2011 02:02 PM |