Firstly I have moved you post to a more appropriate section of the forum.
Please read the section description before posting to find the correct spot.
The purple and black squares means you do not have the texture images in your loaded libraries that are used in the surface materials.
Your missing furniture could be because of a missing library as well.
You should get a 'Library Loading Report' dialogue when you open the file that will tell you items are missing from the loaded libraries.
You need to have the same libraries that the designer used when he made the file - so he will have to send you those libraries as well.
Alternatively he can save the file as an 'Archive' (.PLA) file that contains all the libraries so they are available when you open the file.
Barry.
One of the forum moderators.
Versions 6.5 to 27
i7-10700 @ 2.9Ghz, 32GB ram, GeForce RTX 2060 (6GB), Windows 10
Lenovo Thinkpad - i7-1270P 2.20 GHz, 32GB RAM, Nvidia T550, Windows 11