Excel Automatically number rows so cut and paste works

=Row()-number

number = number of rows down the list.
Then you can cut and paste and it will keep the correct numbers.

In the example Row()=3; number = 2; 3-2=1

AutoCAD Save all system variables to a text file

Express tools...

Express > Tools > System Variable editor

Dialog box not showing up Move Dialog box No Spec Record found because User cancel

Dialog box was hidden on a screen that was disconnected.

Moved the dialog box to the main screen

To move a dialog using just the keyboard:
1. Hold down the ALT key.
2. Press SPACEBAR.
3. Press M (Move).
4. Let go of keys
5. A 4-headed arrow will appear. When it does, use your arrow keys to move the outline of the window.
5. When you are happy with its position, press ENTER.

AutoCAD Architecture Area table Change units

Use  Property Data Formats. Change from meters to Sq. Feet

In Architecture Area
Pick Table
Ribbon > Edit Styles > Property Data Formats.
Select Area and change Real numbers Units to appropriate units.

Autocad hidden line text text won't hide, autocad hide text, autocad text not hiding

Type Hidetext and set to on.



Include Text in HIDE Operations

Specifies whether text objects created by TEXT or MTEXT are included during a HIDE command. ( HIDETEXT system variable)



https://knowledge.autodesk.com/support/autocad-lt/learn-explore/caas/CloudHelp/cloudhelp/2016/ENU/AutoCAD-LT/files/GUID-662D87BB-E8F9-45DB-BC23-AF8F7567BCF9-htm.html

Bentley ProSteel Object enablers not working AutoCAD 2014 Objects not shading

See if objects shade in ProSteel and re-save dwg from ProSteel.
Uninstall and reinstall object enablers pstoe08111187en.exe.
Run the Prereqs for "AutoPLANT" same version. I think the framework might need to be installed maybe new windows updates are causing an issue

Prerequisites and Common Tools for Bentley AutoPLANT V8i (SELECTSeries 6)
English  apr64081111135en.exe

Bentley AUTOPLANT opens wrong version of AutoCAD

Replace AT.ini with a version from a  computer that works or edit the file and change ALL the CADAPP and  AcadCmdLine variable to correct settings.



"C:\ProgramData\Bentley\Plant V8i\CFG\at.ini"



CADAPP=C:\Program Files\Autodesk\AutoCAD 2014\acad.exe





AcadCmdLine=/p "C:\ProgramData\Bentley\Plant V8i\AutoPLANT_Modeler811ACAD_D001_409.arg" /b loadpiping