Open in Excel

• 
  Hi there,
  
  The default save location is an Excel option which can be changed: https://support.office.com/en-us/articl ... 8c60dd5d3b
  
  I hope that helps!

  Jessica R December 12, 2016 18:18

  - 0 +
• 
  According to the instructions in the article, my default file save location is not the same as is offered when I save a file that I've "Open in Excel" from SQL Prompt.
  
  Thanks.

  Gregster December 19, 2016 09:20

  - 0 +
• 
  I am having issues with Open In excel. When excel is already running excel the report begins to export and then excel loads, but an error message pops up on the screen.
  
  Sorry, we couldn't find: C:\user\...\AppData\Local\Temp\XXX\filename xlsx. Is it possible it was moved, renamed or deleted?
  
  When excel is closed it loads up fine with data in the excel and the file can be found in the unique Temp folder just created.
  
  I have repaired Excel but nothing works. I have changed the default save location in excel and still sql prompt tries to save the file temporarily in the temp folder.
  
  Thanks
  Chris
  
  

  tk14ano January 04, 2018 10:31

  - 0 +
• 
  Hi all,
  
  @tk14ano above had also raised a ticket with us and let us know that the issue was resolved by starting Excel in Safemode and trying the "Open in Excel" where they had no issue. After this opening excel normally did not have any problem.
  
  Kind regards,
  Alex

  Alex B January 10, 2018 12:57

  - 0 +
• 
  This started happening to me yesterday, and starting Excel in Safemode fixed the problem. However, today I'm getting the "Sorry, we couldn't find...xlsx. Is it possible it was moved, renamed or deleted?" error when I try to "Open in Excel", and starting Excel in Safemode is not fixing the problem. I can "Open in Excel" if I don't already have Excel open, but subsequent "Open in Excel" attempts result in the error.
  
  

  Leilani April 26, 2018 19:45

  - 0 +
• 
  Hi @Leilani
  
  Thanks for your post. 
  
  Are you on the latest version? If not I've put a link to the download for it below. 
  
  ftp://support.red-gate.com/patches/SQLPrompt/25Apr2018/SQLPrompt_9.1.9.4925.exe
  
  Could you also check to see if the file exists in the location mentioned in the error message please and let us know how you get on? 
  
  Kind regards
  
  Richard Lynch. 

  RichardL April 27, 2018 08:07

  - 0 +
• 

  Leilani said:

  This started happening to me yesterday, and starting Excel in Safemode fixed the problem. However, today I'm getting the "Sorry, we couldn't find...xlsx. Is it possible it was moved, renamed or deleted?" error when I try to "Open in Excel", and starting Excel in Safemode is not fixing the problem. I can "Open in Excel" if I don't already have Excel open, but subsequent "Open in Excel" attempts result in the error.
  
  

  I am glad someone else had this issue because I was afraid it was just me. Mine worked only for a few days and started since then having the issue again. I stopped trying to find a solution to the problem and instead I was exiting all other excel instances (very annoying) before clicking open in Excel.
  

  tk14ano April 27, 2018 08:09

  - 0 +
• 

  RichardL said:

  Hi @Leilani
  
  Thanks for your post. 
  
  Are you on the latest version? If not I've put a link to the download for it below. 
  
  ftp://support.red-gate.com/patches/SQLPrompt/25Apr2018/SQLPrompt_9.1.9.4925.exe
  
  Could you also check to see if the file exists in the location mentioned in the error message please and let us know how you get on? 
  
  Kind regards
  
  Richard Lynch. 

  SP-6883 : 'Open in Excel' grid result operation now works with multiple Excel instances.
  So happy for this.
  Downloading it now and will provide feedback very soon

  tk14ano April 27, 2018 08:10

  - 0 +
• 
  Early feedback...seems to have fixed the issue, at least for now. I will let you know if and when I have it again. Thank you very much for fixing this.

  tk14ano April 27, 2018 08:25

  - 0 +
• 
  Hi @tk14ano
  
  Thanks for your replies. 
  
  I'm glad that all is well with it now. Yes, please do let us know if the issue reoccurs going forward. 
  
  Best
  
  Richard. 

  RichardL April 27, 2018 08:46

  - 0 +
• 
  @RichardL Latest update appears to have fixed the problem for me also. THANKS!
  

  Leilani April 27, 2018 16:56

  - 0 +
• 
  No problem at all @Leilani
  
  
  
  

  RichardL April 30, 2018 09:33

  - 0 +

Add comment

Please sign in to leave a comment.