Thursday, June 13, 2019

MS Office - Opening Word/Excel/PowerPoint file shows file is corrupt or problem with content message


You may get a file corrupt message trying to open a file in Microsoft Office (365) Word, Office Excel or Microsoft Power Point

You may also see
"PowerPoint found a problem with content in 'file'. PowerPoint can attempt to repair the presentation. If you trust the source of the presentation, click Repair."

 And clicking Repair, will give message "Sorry, PowerPoint can't read 'file'"


Alternatively, you may also get a message "The operating system is not presently configured to run this application."




To Solve:
  1. Check the file properties (Right click file and select Properties)
  2. If you see the Option Unblock, check it and click Apply
  3. Open again and see if the error goes away


If the error persist, we can use the Inbuilt Excel (or Word or PowerPoint) repair tool to try to fix

  1. Open new instance of Excel (or Word or PowerPoint) - do not double click the file you need to fix
  2. In the menu, select Open on left
  3. Select Browse



4. Locate the file that need to be fixed and single click to select it
5. Click the down arrow next to the Open Button
6. Select "Open and Repair"


7.  Select Repair


 8. Click Close

9. Open the file again

Wednesday, June 5, 2019

GameMaker Studio 1/2 - replace black bars with sprite

To replace the standard black bars on side, that appear if the room/view size do not match the device size (resolution), do below

  1. Create a sprite with an image that can be tiled. ex: spr_tile_bg
  2. Create a object and place in room
  3. The object created should have just one event, "Pre-Draw" with this line draw_sprite_tiled(spr_tile_bg, 0, 0, 0);

This will tile the image as a background across the entire screen

Turn on Windows 11 Fast Boot

If windows starting is slow, to enable windows 11 fast startup/boot,  Press Windows + R, type powercfg.cpl, and hit Enter.  This will direct...