Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-03-2016, 11:08 AM
cmcmeekin cmcmeekin is offline Error in exporting Google Sheet to Excel Windows 10 Error in exporting Google Sheet to Excel Office 2016
Novice
Error in exporting Google Sheet to Excel
 
Join Date: Aug 2016
Posts: 2
cmcmeekin is on a distinguished road
Question 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?
Reply With Quote
  #2  
Old 08-03-2016, 11:31 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Error in exporting Google Sheet to Excel Windows 7 64bit Error in exporting Google Sheet to Excel Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 08-03-2016, 11:32 AM
cmcmeekin cmcmeekin is offline Error in exporting Google Sheet to Excel Windows 10 Error in exporting Google Sheet to Excel Office 2016
Novice
Error in exporting Google Sheet to Excel
 
Join Date: Aug 2016
Posts: 2
cmcmeekin is on a distinguished road
Default

Thanks; posted there as well.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error in exporting Google Sheet to Excel =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
Error in exporting Google Sheet to Excel Exporting workbook specific sheet columns on exit shabbaranks Excel Programming 4 08-21-2012 08:00 AM
Error in exporting Google Sheet to Excel Exporting to Excel lhicks Outlook 1 07-13-2011 02:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft